Hi, ----------------eredeti üzenet----------------- Feladó: "John Griessen" j...@industromatic.com Címzett: ledger-smb-users@lists.sourceforge.net 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 :) cheers, István ------------------------------------------------------------------------------ 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. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
