where table privileges are stored

Поиск
Список
Период
Сортировка
От Markova, Nina
Тема where table privileges are stored
Дата
Msg-id EAF139F744279142ABF70FFB636112A72BE4A8CA@S-BSC-MBX4.nrn.nrcan.gc.ca
обсуждение исходный текст
Ответы Re: where table privileges are stored
Список 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@nrcan.gc.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----------------------------------------------------------------------------
 
 
 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Matheus de Oliveira
Дата:
Сообщение: Re: [ADMIN] instalação do postgresql93-contrib.x86_64
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: where table privileges are stored