Re: user authorisation checkboxes not visible after copy database

Subject: Re: user authorisation checkboxes not visible after copy database

From: Chris Travers <..hidden..>

Date: Wed, 21 Aug 2013 04:46:44 -0700

On Wed, Aug 21, 2013 at 4:17 AM, Max van Biezen <..hidden..> wrote:

hi,

I have created in 1.3.33 a DB with a little bit of data. I have two valid admin users. Every part of the user credentials is visible and can be edited.

Now I copy this DB, logged on with postgres super-user role, in setup and I copy DB to DB2.

When I log into DB2 the users are there but the check boxes to set the user permissions are not visible. When have added a thrird user with setup and give that full permissions then I do not have the check boxes either.

How can I manually give full permissions to these users in DB2 by editing in psql? Did I miss a step in process? I have not encountered errors.

There is a developer-only setting that can be used to counteract this.

INSERT INTO defaults (setting_key, value) values ('role_prefix', 'lsmb_[old_dbname]__');

This is done so that new users are not granted permissions to the old database unintentionally. If you set that setting, however, the two will be linked in this way.

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more.shtml

------------------------------------------------------------------------------ Introducing Performance Central, a new site from SourceForge and AppDynamics. Performance Central is your source for news, insights, analysis and resources for efficient Application Performance Management. Visit us today! http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk