On Wed, Aug 21, 2013 at 4:17 AM, Max van Biezen <mvanb...@gmail.com> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
