perm question

From: ivan <iv(at)psycho(dot)pl>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: perm question
Date: 2003-07-15 20:16:05
Message-ID: Pine.LNX.4.56.0307152203300.14103@rex.anfa.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

bye
iv

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2003-07-15 20:19:34 Criteria for contrib/ versus gborg?
Previous Message Kurt Roeckx 2003-07-15 20:14:38 Re: OSF build fixed