Hi,
Thanks your suggestion got me going. It does make sense not to grant access
by default. This probably has saved me some painful scenario once into
production ;)
Max
On 21 August 2013 13:46, Chris Travers <chris.trav...@gmail.com> wrote:
>
>
>
> 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
>
>
------------------------------------------------------------------------------
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
