You are now connected as new user postgres.
select has_table_privilege('postgres','pg_shadow','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_shadow','insert');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_shadow','update');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_shadow','delete');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_shadow','rule');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_shadow','references');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_shadow','trigger');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','select') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','insert') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','update') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','delete') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','rule') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','references') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','trigger') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_shadow','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_shadow','insert');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_shadow','update');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_shadow','delete');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_shadow','rule');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_shadow','references');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_shadow','trigger');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_class','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_class','insert');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_class','update');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_class','delete');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_class','rule');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_class','references');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','pg_class','trigger');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','select') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','insert') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','update') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','delete') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','rule') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','references') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','trigger') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_class','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_class','insert');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_class','update');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_class','delete');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_class','rule');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_class','references');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_class','trigger');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

create table testtable(f1 int, f2 text);
CREATE
select has_table_privilege('postgres','testtable','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','testtable','insert');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','testtable','update');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','testtable','delete');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','testtable','rule');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','testtable','references');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres','testtable','trigger');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','select') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','insert') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','update') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','delete') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','rule') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','references') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','trigger') from (select usesysid from pg_user where usename = 'postgres') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('postgres',t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','insert');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','update');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','delete');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','rule');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','references');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','trigger');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

create user foo;
CREATE USER
grant all on testtable to foo;
CHANGE
You are now connected as new user foo.
select has_table_privilege('foo','pg_shadow','select');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_shadow','insert');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_shadow','update');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_shadow','delete');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_shadow','rule');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_shadow','references');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_shadow','trigger');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','select') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','insert') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','update') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','delete') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','rule') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','references') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_shadow','trigger') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_shadow','select');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_shadow','insert');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_shadow','update');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_shadow','delete');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_shadow','rule');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_shadow','references');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_shadow','trigger');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_shadow') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_class','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo','pg_class','insert');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_class','update');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_class','delete');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_class','rule');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_class','references');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','pg_class','trigger');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','select') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','insert') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','update') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','delete') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','rule') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','references') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t2.usesysid,'pg_class','trigger') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo',t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo',t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

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;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_class','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('pg_class','insert');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_class','update');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_class','delete');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_class','rule');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_class','references');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('pg_class','trigger');
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'pg_class') as t1;
 has_table_privilege 
---------------------
 f
(1 row)

select has_table_privilege('foo','testtable','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo','testtable','insert');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo','testtable','update');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo','testtable','delete');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo','testtable','rule');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo','testtable','references');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo','testtable','trigger');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','select') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','insert') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','update') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','delete') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','rule') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','references') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t2.usesysid,'testtable','trigger') from (select usesysid from pg_user where usename = 'foo') as t2;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo',t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo',t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo',t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo',t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo',t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo',t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('foo',t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

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;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','select');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','insert');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','update');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','delete');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','rule');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','references');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege('testtable','trigger');
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'select') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'insert') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'update') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'delete') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'rule') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'references') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

select has_table_privilege(t1.oid,'trigger') from (select oid from pg_class where relname = 'testtable') as t1;
 has_table_privilege 
---------------------
 t
(1 row)

You are now connected as new user postgres.
drop user foo;
DROP USER
drop table testtable;
DROP