Re: Table permissions

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: Milen Dzhumerov <gamehack(at)gmail(dot)com>
Subject: Re: Table permissions
Date: 2006-03-26 23:10:04
Message-ID: 200603270110.04407.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message adey 2006-03-26 23:54:48 Re: Bloated pg_shdepend_depender_index
Previous Message Milen Dzhumerov 2006-03-26 20:34:51 Table permissions