[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: Steven Marshall <..hidden..>
- Date: Thu, 17 Nov 2011 11:38:15 -0200
Sent from my iPad
On Nov 17, 2011, at 4:33 AM, Chris Travers <..hidden..> wrote:
> On Mon, Nov 7, 2011 at 8:29 AM, Steven Marshall
> <..hidden..> wrote:
>> I am trying to understand the purpose of the Super User that is used on the
>> initial screen of Setup.pl. I have created a Superuser called "ledgersmb"
>> with a password in PostgreSQL.
> You could use "postgres" instead of "ledgersmb." It just has to be a
> superuser. This is a database user which creates and sets up the
> database for you.
You state that it just needs to be a superuser. I created the
ledgersmb user as a superuser using the following:
CREATE USER ledgersmb WITH superuser password 'somepassword';
After this I run setup.pl to create my database specifying 'ledgersmb'
as the superuser. I am expecting to be able to login to my new
database using 'ledgersmb' superuser account. Unless I am
misunderstanding something, the "postgres" and "ledgersmb" accounts in
my system are both superusers are they not? Both should be able to
login at this point?
>> I then proceed to create a new company using
>> Setup.pl using my superuser "ledgersmb". After successfully creating my new
>> company, I am not able to login to the new company's ledgersmb instance
>> using the superuser "ledgersmb" role. I am able to login with the user
>> account that was created during the company creation process using Setup.pl
>> and also with any other user I add via the Ledgersmb UI.
> That is correct.
>> 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.
>> For example, I
>> may help manage/troubleshoot their users' role permissions for example. I
>> was expecting to be able to do that using the superuser account, but it
>> appears that the only way to do this would be to create a new user for each
>> company for myself so that I could be the Super Administrator for example.
> Not quite correct. The "import" switch allows you to import an
> existing postgresql user for the administrator account.
>> If 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?
> If you import the account into all the other databases, the password
> management is consistent across the databases. However, you are not
> guaranteed the same permissions on all databases. You could have one
> set on one database and another set on another.
> Hope this helps,
> Chris Travers
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> Ledger-smb-users mailing list