[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Ledgersmb 1.3.3: Super User can't login to company database
- Subject: Re: Ledgersmb 1.3.3: Super User can't login to company database
- From: HÃvardSÃrli <..hidden..>
- Date: Thu, 17 Nov 2011 05:56:56 +0000 (UTC)
Steven Marshall <..hidden..> writes:
> The use case I am trying to resolve is the following. ÂIf I manage several
>companies on Ledgersmb, it would be useful to be able to login to any of these
>companies' ledgersmb instances to help resolve issues. Â
>I have 100 companies though on my system and decide to change my password,
>wouldn't I have to change it a 100 times (one for each company)? ÂWhat would be
>the best approach to setting up a Super Administrator?
I agree that we have to find a solution to this. I have done some testing with
one user, an added roles to it from both databases. I can't get it to work.
There are another important usercase, and that is accounting firms. They need a
way to add the same user to several db's.
I've managed to add the roles of each database to the same user with:
ALTER USER <usernaname> SET ROLE lsmb_ <dbname> __system_admin;
but I still can not log into other databases than where the user was created.
Is there anyone else who has suggestions for a solution?