RE: Permissions on Tables
От | Luis Magaña |
---|---|
Тема | RE: Permissions on Tables |
Дата | |
Msg-id | SAK.2000.10.31.joijhhsr@thor обсуждение исходный текст |
Ответ на | Permissions on Tables (Luis Magaña <joe666@gnovus.com>) |
Список | pgsql-general |
Thanks, that was the solution -- Luis Magaña Gnovus Networks & Software www.gnovus.com Tel. +52 (7) 4422425 joe666@gnovus.com Original message from: "Edmar Wiggers" >Try using adding -E option to psql. It will show you the queries used to >answer \d* (and other) commands. > >psql -E test >test=> \dp >********* QUERY ********* >SELECT relname as "Relation", > relacl as "Access permissions" >FROM pg_class >WHERE ( relkind = 'r' OR relkind = 'S') AND > relname !~ '^pg_' >ORDER BY relname >************************* >... > >> I'm writing a interface that should manage users groups and >> permissions on tables in a database. Have almost completed users >> and groups handling, but now I'm facing a problem... How can I >> find out what >> are the permissions on a table without using \dp ?. This should >> be done through a SELECT or something similar. Thanks for any >> help gentlemans. > >Take care, > >Edmar > >
В списке pgsql-general по дате отправления: