My postgresql version is 7.2.1, i found a user's acl information remained when i deleted the user.
login as a superuser(postgres).
create a table called films in currnet database.
create a user called filmuser.
grant select on films to filmuser.
filmuser now can select on films.
create user filmuser again with same sysid as the privious one.
i find the new filmuser can select on table films, without granting statement excuted.
pgsql-bugs by date
|Next:||From: Kallol Nandi||Date: 2003-06-20 07:23:05|
|Subject: JDBC in PostgreSql for Linux|
|Previous:||From: Enke, Michael||Date: 2003-06-19 13:40:37|
|Subject: again: Bug #943: Server-Encoding from EUC_TW to UTF-8 doesn'twork|