SEO

#1 (**permalink**) 04-12-2008, 08:51 AM

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.

#2 (**permalink**) 04-12-2008, 08:51 AM

"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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Role privileges in PostgreSQL.