Re: Table permissions - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Table permissions
Date
Msg-id 200603270110.04407.peter_e@gmx.net
Whole thread Raw
In response to Table permissions  (Milen Dzhumerov <gamehack@gmail.com>)
Responses Re: Table permissions
List pgsql-admin
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
> or shared across PgSQL?

Most of them are per database, only a few of them are shared.

> Is is true that every user can check if
> he/she has access to a particular table and examine the ACL string?

Yes.

> And how can I determine if a user can change permissions for other
> users?

You can check the grant options available to the user.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-admin by date:

Previous
From: Milen Dzhumerov
Date:
Subject: Table permissions
Next
From: adey
Date:
Subject: Re: Bloated pg_shdepend_depender_index