Postgres Pro
Downloads
Home   >   mailing lists

Re: table permissions - Mailing list pgsql-admin

From Ian Barwick
Subject Re: table permissions
Date
Msg-id 200111251800.TAA04897@post.webmailer.de
Whole thread Raw
In response to table permissions  (MG <makgab@freemail.hu>)
List pgsql-admin
Tree view 
On Thursday 22 November 2001 11:39, MG wrote:
> Hi!
>
> I subscribe to this list now. :) I have a question.
> How can I query (in SQL) the user permissions of a table? Which system
> table stores the tables permissions for the user?

Sounds like you are looking for table pg_class, column relacl.
See:

http://www.postgresql.org/idocs/index.php?catalog-pg-class.html

HTH

Ian Barwick

pgsql-admin by date:

Previous
From: "Chad R. Larson"
Date:
Subject: Re: Problems between Mandrake and pg
Next
From: Ian Barwick
Date:
Subject: Re: table permissions