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----------------------------------------------------------------------------
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 |