Re: user authorisation checkboxes not visible after copy database

On 21 August 2013 13:46, Chris Travers <..hidden..> wrote:

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
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users