[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: 1.3.36 install on debian testing

----------------eredeti üzenet-----------------
Feladó: "John Griessen" ..hidden.. 
Címzett: ..hidden.. 
Dátum: Tue, 21 Jan 2014 08:34:45 -0600
> Hi, I created an initial user with all permissions and it made the \du listing
> from psql have many new roles plus huge long lists of roles.
> Is that a normal situation, where \du fills the screen?

Yes, it is pretty normal. 
More than 100 group roles exist, because ACL provided via them.
When you will add more users to your system, you will find a big screen, where you can add these group roles to your new or existing users.
For example you can disable making invoices, but allow to make offers and orders etc.

> Can the initial user practically have just manage users level of permissions,
> or is full permissions the correct choice? I already have a user that I logged 
> into
> postgres with that can create users and databases. Can the initial ledgersmb
> user be that same user also?
> John

Depends on your strategy. 
You can use one login role for all your lsmb databases with only managing users. This user is only for adding real users to a database in a multi company environment.

If you just use it alone, you can give that user a full permission.

My recommendation, separate your users from that user, which already part of your postgres with admin rights.

I hope it helps :)


CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
Ledger-smb-users mailing list