Postgres Pro
Downloads
Home   >   mailing lists

Permissions for system tables - Mailing list pgsql-general

From Richard Ray
Subject Permissions for system tables
Date
Msg-id 200208261401.g7QE1Ps17271@rray.mstc.state.ms.us
Whole thread Raw
Responses Re: Permissions for system tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
How can I determine the permissions for system tables?
It seems any user I create has access.
psql \z only shows permissions for user tables.
I checked relacl in pg_class but it's blank for all but user tables.

Thanks
Richard

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Triggers: How to make one that fires at a certain
Next
From: Tom Lane
Date:
Subject: Re: Permissions for system tables