Steven Marshall <steven.marshall@...> 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? -- H ------------------------------------------------------------------------------ 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. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
