Обсуждение: Reading privileges

Поиск
Список
Период
Сортировка

Reading privileges

От
Kublai Khan
Дата:
Hiho,

How does one fetch the privileges on a PostgreSQL table from SQL?  I'm
looking for the SQL equivalent of psql's "\z".  In Oracle, this would be
"describe user_tab_priv".

Thanks!


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

Re: Reading privileges

От
GH
Дата:
On Thu, Nov 30, 2000 at 05:01:10PM -0800, some SMTP stream spewed forth:
> Hiho,
>
> How does one fetch the privileges on a PostgreSQL table from SQL?  I'm
> looking for the SQL equivalent of psql's "\z".  In Oracle, this would be
> "describe user_tab_priv".

I cannot tell you off the top of my head, but if you do `psql -E` it will
show the commands it uses for such things as \z, etc.

gh

>
> Thanks!
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----