\connect - postgres -- -- user postgres, rel pg_shadow -- select has_table_privilege('postgres','pg_shadow','select'); select has_table_privilege('postgres','pg_shadow','insert'); select has_table_privilege('postgres','pg_shadow','update'); select has_table_privilege('postgres','pg_shadow','delete'); select has_table_privilege('postgres','pg_shadow','rule'); select has_table_privilege('postgres','pg_shadow','references'); select has_table_privilege('postgres','pg_shadow','trigger'); select has_table_privilege(t2.usesysid,'pg_shadow','select') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','insert') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','update') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','delete') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','rule') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','references') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','trigger') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege('postgres',t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('postgres',t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('postgres',t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('postgres',t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('postgres',t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('postgres',t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('postgres',t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t2.usesysid,t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege('pg_shadow','select'); select has_table_privilege('pg_shadow','insert'); select has_table_privilege('pg_shadow','update'); select has_table_privilege('pg_shadow','delete'); select has_table_privilege('pg_shadow','rule'); select has_table_privilege('pg_shadow','references'); select has_table_privilege('pg_shadow','trigger'); select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1; -- -- user postgres, rel pg_class -- select has_table_privilege('postgres','pg_class','select'); select has_table_privilege('postgres','pg_class','insert'); select has_table_privilege('postgres','pg_class','update'); select has_table_privilege('postgres','pg_class','delete'); select has_table_privilege('postgres','pg_class','rule'); select has_table_privilege('postgres','pg_class','references'); select has_table_privilege('postgres','pg_class','trigger'); select has_table_privilege(t2.usesysid,'pg_class','select') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_class','insert') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_class','update') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_class','delete') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_class','rule') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_class','references') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'pg_class','trigger') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege('postgres',t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('postgres',t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('postgres',t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('postgres',t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('postgres',t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('postgres',t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('postgres',t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t2.usesysid,t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege('pg_class','select'); select has_table_privilege('pg_class','insert'); select has_table_privilege('pg_class','update'); select has_table_privilege('pg_class','delete'); select has_table_privilege('pg_class','rule'); select has_table_privilege('pg_class','references'); select has_table_privilege('pg_class','trigger'); select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1; -- -- create rel testtable -- create table testtable(f1 int, f2 text); -- -- user postgres, rel testtable -- select has_table_privilege('postgres','testtable','select'); select has_table_privilege('postgres','testtable','insert'); select has_table_privilege('postgres','testtable','update'); select has_table_privilege('postgres','testtable','delete'); select has_table_privilege('postgres','testtable','rule'); select has_table_privilege('postgres','testtable','references'); select has_table_privilege('postgres','testtable','trigger'); select has_table_privilege(t2.usesysid,'testtable','select') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'testtable','insert') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'testtable','update') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'testtable','delete') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'testtable','rule') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'testtable','references') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,'testtable','trigger') from (select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege('postgres',t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('postgres',t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('postgres',t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('postgres',t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('postgres',t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('postgres',t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('postgres',t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t2.usesysid,t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege(t2.usesysid,t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'postgres') as t2; select has_table_privilege('testtable','select'); select has_table_privilege('testtable','insert'); select has_table_privilege('testtable','update'); select has_table_privilege('testtable','delete'); select has_table_privilege('testtable','rule'); select has_table_privilege('testtable','references'); select has_table_privilege('testtable','trigger'); select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1; -- -- create new user, grant all on testtable, and connect -- create user foo; grant all on testtable to foo; \connect - foo -- -- user foo, rel pg_shadow -- select has_table_privilege('foo','pg_shadow','select'); select has_table_privilege('foo','pg_shadow','insert'); select has_table_privilege('foo','pg_shadow','update'); select has_table_privilege('foo','pg_shadow','delete'); select has_table_privilege('foo','pg_shadow','rule'); select has_table_privilege('foo','pg_shadow','references'); select has_table_privilege('foo','pg_shadow','trigger'); select has_table_privilege(t2.usesysid,'pg_shadow','select') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','insert') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','update') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','delete') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','rule') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','references') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_shadow','trigger') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege('foo',t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('foo',t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('foo',t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('foo',t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('foo',t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('foo',t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege('foo',t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t2.usesysid,t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege('pg_shadow','select'); select has_table_privilege('pg_shadow','insert'); select has_table_privilege('pg_shadow','update'); select has_table_privilege('pg_shadow','delete'); select has_table_privilege('pg_shadow','rule'); select has_table_privilege('pg_shadow','references'); select has_table_privilege('pg_shadow','trigger'); select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1; select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1; -- -- user foo, rel pg_class -- select has_table_privilege('foo','pg_class','select'); select has_table_privilege('foo','pg_class','insert'); select has_table_privilege('foo','pg_class','update'); select has_table_privilege('foo','pg_class','delete'); select has_table_privilege('foo','pg_class','rule'); select has_table_privilege('foo','pg_class','references'); select has_table_privilege('foo','pg_class','trigger'); select has_table_privilege(t2.usesysid,'pg_class','select') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_class','insert') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_class','update') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_class','delete') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_class','rule') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_class','references') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'pg_class','trigger') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege('foo',t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('foo',t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('foo',t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('foo',t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('foo',t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('foo',t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege('foo',t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t2.usesysid,t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege('pg_class','select'); select has_table_privilege('pg_class','insert'); select has_table_privilege('pg_class','update'); select has_table_privilege('pg_class','delete'); select has_table_privilege('pg_class','rule'); select has_table_privilege('pg_class','references'); select has_table_privilege('pg_class','trigger'); select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1; select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1; -- -- user foo, rel testtable -- select has_table_privilege('foo','testtable','select'); select has_table_privilege('foo','testtable','insert'); select has_table_privilege('foo','testtable','update'); select has_table_privilege('foo','testtable','delete'); select has_table_privilege('foo','testtable','rule'); select has_table_privilege('foo','testtable','references'); select has_table_privilege('foo','testtable','trigger'); select has_table_privilege(t2.usesysid,'testtable','select') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'testtable','insert') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'testtable','update') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'testtable','delete') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'testtable','rule') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'testtable','references') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,'testtable','trigger') from (select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege('foo',t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('foo',t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('foo',t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('foo',t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('foo',t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('foo',t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege('foo',t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t2.usesysid,t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege(t2.usesysid,t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1,(select usesysid from pg_user where usename = 'foo') as t2; select has_table_privilege('testtable','select'); select has_table_privilege('testtable','insert'); select has_table_privilege('testtable','update'); select has_table_privilege('testtable','delete'); select has_table_privilege('testtable','rule'); select has_table_privilege('testtable','references'); select has_table_privilege('testtable','trigger'); select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1; select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1; -- -- Clean up -- \connect - postgres drop user foo; drop table testtable;