Search Postgresql Archives

Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Louis Lam" <louis.lam@xxxxxxxxxxxx> writes:
> In PostgreSQL, there are some grant privileges like grant on SEQUENCE,
> DATABASE, LANGUAGE, SCHEMA and DATABASE.  I grant and revoke these
> privleges on my PostgreSQL on Windows and Linux OS.  But once it is
> granted, how do I find out what user and role are granted with these
> privileges?

It's stored in the various "acl" columns of the system catalogs, which
you can look at either directly or via psql's \d commands.  See the
GRANT reference page for an example and a discussion of how to read
the entries.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux