Re: table permissions

From: Ian Barwick <barwick(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: table permissions
Date: 2001-11-25 17:01:54
Message-ID: 200111251800.TAA04897@post.webmailer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andre Schubert 2001-11-26 09:56:51 Re: [Fwd: [Zope-dev] Authentication Problem with Postgres]
Previous Message Ian Barwick 2001-11-24 23:06:28 Re: Problems between Mandrake and pg