Permissions for system tables
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
Richard Ray <rray1@netdoor.com> writes:
How can I determine the permissions for system tables?
The default permissions for system catalogs are world read, other
privileges for owner (postgres) only.
You can try restricting the world read if you like, but be advised
that it's likely to break clients that expect to be able to inspect
the system catalogs.
regards, tom lane
I don't want to change anything. I'm just learn'n.
Is there somewhere I can lookup the assignment for system tables and views?
Show quoted text
On Monday 26 August 2002 09:11 am, you wrote:
Richard Ray <rray1@netdoor.com> writes:
How can I determine the permissions for system tables?
The default permissions for system catalogs are world read, other
privileges for owner (postgres) only.You can try restricting the world read if you like, but be advised
that it's likely to break clients that expect to be able to inspect
the system catalogs.regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly