pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
privilege & user
2+ messages / 2 participants
[nested] [flat]

* privilege & user
@ 2005-07-11 20:20  Lee Wu <Lwu@mxlogic.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Lee Wu @ 2005-07-11 20:20 UTC (permalink / raw)
  To: pgsql-admin

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
***

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: privilege & user
@ 2005-07-11 20:33  Alvaro Herrera <alvherre@alvh.no-ip.org>
  parent: Lee Wu <Lwu@mxlogic.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2005-07-11 20:33 UTC (permalink / raw)
  To: Lee Wu <Lwu@mxlogic.com>; +Cc: pgsql-admin

On Mon, Jul 11, 2005 at 02:20:52PM -0600, Lee Wu wrote:

> Here is my test, I think the privilege should be revoked automatically.

Long-standing known bug.  Fixed in 8.1.

-- 
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"La persona que no querĂ­a pecar / estaba obligada a sentarse
 en duras y empinadas sillas    / desprovistas, por cierto
 de blandos atenuantes"                          (Patricio Vogel)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-07-11 20:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-11 20:20 privilege & user Lee Wu <Lwu@mxlogic.com>
2005-07-11 20:33 ` Alvaro Herrera <alvherre@alvh.no-ip.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox