View Single Post

   
  #2 (permalink)  
Old 04-12-2008, 08:51 AM
Tom Lane
 
Posts: n/a
Default Re: Role privileges in PostgreSQL.

"Akmal Akmalhojaev" <akmal.ilh@gmail.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/pgdo.../catalogs.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote