From: Ian Barwick <barwick@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Re: table permissions
Date: Sun, 25 Nov 2001 18:01:54 +0100
Message-ID: <200111251800.TAA04897@post.webmailer.de> (raw)
In-Reply-To: <XFMail.20011122103937.makgab@freemail.hu>
References: <XFMail.20011122103937.makgab@freemail.hu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: barwick@gmx.net
Subject: Re: table permissions
In-Reply-To: <200111251800.TAA04897@post.webmailer.de>
References: <XFMail.20011122103937.makgab@freemail.hu> <200111251800.TAA04897@post.webmailer.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox