|
Hi, Here is my test, I think the privilege should be revoked
automatically. Otherwise, it is a dangerous thing: bash-2.05b$ createdb dod CREATE DATABASE bash-2.05b$ psql dod Welcome to psql 8.0.3, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL
commands \? for help with psql
commands \g or terminate with
semicolon to execute query \q to quit dod=# create user secretary_dod; CREATE USER dod=# create table terror (c1 int); CREATE TABLE dod=# grant select on terror to secretary_dod; GRANT dod=# \z terror
Access privileges for database "dod" Schema | Name | Type
|
Access privileges --------+--------+-------+------------------------------------------------------ public | terror | table |
{postgres=arwdRxt/postgres,secretary_dod=r/postgres} (1 row) dod=# drop user secretary_dod; DROP USER dod=# \z terror
Access privileges for database "dod" Schema | Name | Type
|
Access privileges --------+--------+-------+-------------------------------------------- public | terror | table |
{postgres=arwdRxt/postgres,103=r/postgres} (1 row) dod=# create user a_staff SYSID 103; CREATE USER dod=# \c - a_staff You are now connected as new user "a_staff". dod=> select * from terror; c1 ---- (0 rows) *** WOW!, A_staff can what the Secretary of Dept of Defense
could see *** |
