Thanks Kretschmer but I have seen those function. The below query returns error but you could see that 'user1' has ALL permissions on table 'techtable'.
techdb=# SELECT has_table_privilege('user1', 'techtable', 'ALL'); ERROR: unrecognized privilege type: "ALL" techdb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn where pc.relnamespace=pn.oid and pn.nspname='techdb' and pc.relname='techtable'; relname | relacl -----------+------------------------------------------------------------------- techtable | {postgres=arwdDxt/postgres,=ar/postgres,user1=arwdDxt/postgres} (1 row) Do I have to run this command as below which includes all permissions explicitly? Did I miss anything? techdb=# SELECT has_table_privilege('user1', 'techtable', 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'); has_table_privilege --------------------- t (1 row) Thanks, Dipti On Thu, Apr 15, 2010 at 1:27 PM, A. Kretschmer < andreas.kretsch...@schollglas.com> wrote: > In response to dipti shah : > > > > Hi, I have granted ALL permissions on 'techtable' to 'user1'. > > > > techdb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn > where > > pc.relnamespace=pn.oid and pn.nspname='techdb' and > pc.relname='techtable'; > > relname | relacl > > > -----------+------------------------------------------------------------------- > > techtable | > {postgres=arwdDxt/postgres,=ar/postgres,user1=arwdDxt/postgres} > > (1 row) > > > > Could anyone please tell me if there is any function or command in > PostGreSql > > which returns True if given user has ALL permissions on given table? Is > there > > Sure, read > http://www.postgresql.org/docs/8.4/interactive/functions-info.html > > > Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) > GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >