PGBUGS£¬
Short Description
Drop user cannot delete the correspoding permission and cannot change the owner of
the namespace.
Long Description
When I droped a user, the all permission granted by other user cannot be deleted.
The all SQL statements show as the follow:
test=# CREATE user userb; --user test is a superuser and the database is test.
CREATE USER
test=# GRANT SELECT on b to userb;
GRANT
test=# c test userb
You are now connected to database test as user userb.
test=> SELECT * from b; --the table b is public.b
id
----
(0 rows)
test=> c
You are now connected to database test as user test.
test=# drop user userb;
DROP USER
test=# CREATE user userc;
CREATE USER
test=# c test userc
You are now connected to database test as user userc.
test=> SELECT * from b; --the table b is public.b
a
---
(0 rows)
When I got these message, and checked the system catalog pg_shadow ,
and find the droped userb and new user userc had same usesysid.
And more, Superuser test create a schema for userb, the userc got the schema
for userc has the same usesysid as userb;
I think this is permission leak.
bigapple
2003.1.17.
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
¡¡
¡¡¡¡¡¡¡¡¡¡¡¡¡¡
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡2003-01-17
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
