Thread: Reading privileges

Reading privileges

From
Kublai Khan
Date:
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

From
GH
Date:
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! =-----