Lists: | pgsql-hackers |
---|
From: | "Akmal Akmalhojaev" <akmal(dot)ilh(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Role privileges in PostgreSQL. |
Date: | 2007-05-25 22:22:14 |
Message-ID: | ae5aee560705251522i6f392488v92c145de640418bd@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hello.
I have the following question: where role privileges on working with tables,
data bases and so on are stored in PostgreSQL (In what system catalogs?)?
Thanks.
Akmal.
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Akmal Akmalhojaev" <akmal(dot)ilh(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Role privileges in PostgreSQL. |
Date: | 2007-05-25 23:49:35 |
Message-ID: | 28263.1180136975@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
"Akmal Akmalhojaev" <akmal(dot)ilh(at)gmail(dot)com> writes:
> I have the following question: where role privileges on working with tables,
> data bases and so on are stored in PostgreSQL (In what system catalogs?)?
Privileges are attached to the target objects, eg pg_class.relacl for
relations. Look for columns of type aclitem[] in the catalog descriptions:
http://developer.postgresql.org/pgdocs/postgres/catalogs.html
regards, tom lane