Important SQL's for Greenplum DBA's

Post date: May 02, 2013 10:56:8 PM

select count(*) from pg_tables where schemaname='sachi';

select rolname from pg_roles where rolcanlogin is TRUE; -- List users

select rolname from pg_roles where rolcanlogin is FALSE; --- List Roles

select * from pg_views ;

select * from information_schema.table_privileges;

select * from pg_user;

select * from pg_views where viewname like '%priv%';

select * from pg_views where viewname like '%role%';

select * from pg_views where viewname like '%gran%';

select * from pg_views where viewname like '%part%';

select * from pg_views where viewname like '%schema%';

select * from pg_views where viewname like '%stat%';

select * from information_schema.role_table_grants;

select * from information_schema.role_routine_grants;

select * from information_schema.applicable_roles;

select * from information_schema.enabled_roles;

select * from gp_toolkit.gp_roles_assigned;