Perfect, thanks. Nina -----Original Message----- From: Stephen Frost [mailto:sfrost@xxxxxxxxxxx] Sent: May-07-15 11:07 To: Markova, Nina Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: where table privileges are stored Nina, * Markova, Nina (Nina.Markova@xxxxxxxxxxxxxxxxx) wrote: > I need to check in a GUI if a user has certain privileges on the table he is trying to modify - insert/update/delete. You probably want to use the "has_table_privilege" family of functions. Look here: http://www.postgresql.org/docs/9.4/static/functions-info.html > Something I could query system catalogs about: > Select ... from ... where table_name = 'MYTABLE'; > > Does Postgres store user privileges on tables in format similar to the one below, I mean the info below to be stored as a text field somewhere? > grant delete on MYTABLE to myuser > grant insert on MYTABLE to myuser Privileges are stored in the catalog tables but not is a terribly useful format for querying, which is why the helper functions exist. If you want to look at it though, look at pg_class.relacl. Thanks! Stephen -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
