where table privileges are stored

From: "Markova, Nina" <Nina(dot)Markova(at)NRCan-RNCan(dot)gc(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Cc: "Markova, Nina" <Nina(dot)Markova(at)NRCan-RNCan(dot)gc(dot)ca>
Subject: where table privileges are stored
Date: 2015-05-07 14:53:33
Message-ID: EAF139F744279142ABF70FFB636112A72BE4A8CA@S-BSC-MBX4.nrn.nrcan.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I need to check in a GUI if a user has certain privileges on the table he is trying to modify - insert/update/delete.
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

Thanks,
Nina

-----'\/\/\/`v^v^v^v^v^v^v----------------------------------------------------------------------------

Nina Markova,
Database Analyst / Analyst de base de données
email/courriel: nmarkova(at)nrcan(dot)gc(dot)ca

Infrastructure & Development Group / Groupe de l'infrastructure et du developpement
Canadian Hazards Information Service / Service canadien d'informations sur les risques
Earth Sciences Sector / Secteur des sciences de la Terre
Natural Resources Canada / Ressources naturelles Canada

-----'\/\/\/`v^v^v^v^v^v^v----------------------------------------------------------------------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Frost 2015-05-07 15:07:26 Re: where table privileges are stored
Previous Message Matheus de Oliveira 2015-05-07 14:11:19 Re: [ADMIN] instalação do postgresql93-contrib.x86_64