Peter Eisentraut wrote:
Milen Dzhumerov wrote:
Unfortunately if I try to submit it, it gives me some
error.
You need to post your exact input and the exact output. Otherwise we're
just guessing.
My other
question is who has access to the pg_catalog.* tables?
Everybody.
Milen Dzhumerov wrote:
> Unfortunately if I try to submit it, it gives me some
> error.
You need to post your exact input and the exact output. Otherwise we're
just guessing.
> My other
> question is who has access to the pg_catalog.* tables?
Everybody.
> And are these tables per database
> o
Hi all,
I had the need to find the user permissions of several tables. I figured
out that if I submit the query
SELECT relacl FROM pg_catalog.pg_class WHERE relname = 'tablename';
I get the permissions but for the table name in all schemas and not only
the one I'm interested in. Then I took a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 2001 November 22 05:39 am, MG wrote:
> 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?
psql -E test
\dp
displays the
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.
S
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:
h
At 10:39 AM 11/22/01 +, MG wrote:
>How can I query (in SQL) the user permissions of a table? Which system table
>stores the tables permissions for the user?
select * from pg_user ;
-crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
Eldorado Computing, Inc. 602-604-3100
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?
Bye!
Linux Redhat 7.1
---(end of broadcast)