perm question - Mailing list pgsql-hackers

From ivan
Subject perm question
Date
Msg-id Pine.LNX.4.56.0307152203300.14103@rex.anfa.pl
Whole thread Raw
Responses Re: perm question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
hi,
why when i revoke all on scheme pg_catalog from all (with public)
i can make select from pg_ tables and views as ordinary user ??
I can usage this scheme so why i can makeing select ?

Then i remove SELECT perm from PUBLIC on pg_ tables and then i cant
makeing select from this tables , but i can make select from views,
even i dont have perm to do select from src tables of thises views.

what do you this about using RE in select , or only rel names like :
revoke all on table pg_* from public ? etc ?

and how disallow : LISTEN , SET , RESET , and SHOW ?

byeiv



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] problems with pg_restore
Next
From: Kurt Roeckx
Date:
Subject: Re: OSF build fixed