sorry that query is wrong. Use this one
SELECT admin__add_user_to_role('[username]', rolname)
FROM pg_roles
WHERE rolname like 'lsmb_' || current_database() || '__%';
On Sat, Oct 8, 2011 at 11:59 AM, Chris Travers <[email protected]> wrote:
> And you will need to then to add your user to roles. If you want to
> give your role full perms:
>
> SELECT admin__add_user_to_role('[username]', rolname)
> FROM pg_roles
> WHERE rolname like 'lsmb_' || current_database();
>
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of 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-d2dcopy2
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
