Re: Bug #746: Drop user damages security on tables
От | Thomas Lockhart |
---|---|
Тема | Re: Bug #746: Drop user damages security on tables |
Дата | |
Msg-id | 3D6ACEA1.182B2AC1@fourpalms.org обсуждение исходный текст |
Ответ на | Bug #746: Drop user damages security on tables (pgsql-bugs@postgresql.org) |
Ответы |
Re: Bug #746: Drop user damages security on tables
|
Список | pgsql-bugs |
> > A user was setup and had GRANT permissions on individual tables in a database. After the user was dropped, using the/z from psql command line showed the user ID still existing in the individual table permissions. After the drop, severalother users then were unable to execute SELECT or INSERT on this table. These users would get a -601 error when tryingto do a SELECT or INSERT. Also, trying to REVOKE permissions on the user ID that belonged to the dropped user resultedin a parse error. > What is a "-601 error"? There's surely no such message in Postgres. There surely is in ecpg: ecpgerrno.h:#define ECPG_WARNING_QUERY_IGNORED -601 These error codes are typically chosen to conform to SQL9x or to Oracle's conventions, though I haven't looked into this one in a while... - Thomas
В списке pgsql-bugs по дате отправления: