Re: [GENERAL] Listing privileges on a schema

2013-08-16 Thread Adrian Klaver
On 08/16/2013 10:27 AM, David Salisbury wrote: Hello, Is there a query out there where I can get a list of permissions associated to a schema? Something like the below query that I can do for a table, but for a schema instead? SELECT grantee, privilege_type FROM information_schema.role_tabl

[GENERAL] Listing privileges on a schema

2013-08-16 Thread David Salisbury
Hello, Is there a query out there where I can get a list of permissions associated to a schema? Something like the below query that I can do for a table, but for a schema instead? SELECT grantee, privilege_type FROM infor