Re: [BUGS] Bug #746: Drop user damages security on tables

2002-08-26 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: >> 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 Hmm ... maybe, but a query-ignored failure could only happen in the case of multiple comm

Re: [BUGS] Bug #746: Drop user damages security on tables

2002-08-26 Thread Thomas Lockhart
> > 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, several other >users then were unable to execute SELECT o

Re: [BUGS] Bug #746: Drop user damages security on tables

2002-08-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > 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, several other >users then were un

[BUGS] Bug #746: Drop user damages security on tables

2002-08-26 Thread pgsql-bugs
Mickey Parker ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Drop user damages security on tables Long Description A user was setup and had GRANT permissions on individual tables in a database. After the user was dropped, us