Re: table permissions

From: Ian Barwick <barwick(at)gmx(dot)net>
To: MG <makgab(at)freemail(dot)hu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: table permissions
Date: 2001-11-24 22:46:27
Message-ID: 200111242246.XAA16488@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 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 Ian Barwick 2001-11-24 23:06:28 Re: Problems between Mandrake and pg
Previous Message Yuri A. Kabaenkov 2001-11-24 14:15:34 postgresql 7.1.3 on freebsd 4.4