how to delete access rights from non-existent user ?
От | David Sauer |
---|---|
Тема | how to delete access rights from non-existent user ? |
Дата | |
Msg-id | m2r9nu771v.fsf@orfinet.cz обсуждение исходный текст |
Список | pgsql-sql |
Hello, Now, the problem: (current CVS snapshot) Suppose, we have user "test" (uid=1000), which has some rights on some table. Ex.: Database = david+----------+-----------------------------+| Relation | Grant/Revoke Permissions |+----------+-----------------------------+|t | {"=","postgres=a","test=a"} |+----------+-----------------------------+ Now, I delete user "test" from database: david=> drop user test; DROP USER david=> \z Database = david+----------+-----------------------------+| Relation | Grant/Revoke Permissions |+----------+-----------------------------+|t | {"=","postgres=a","1000=a"} |+----------+-----------------------------+ david=> revoke all on t from 1000; ERROR: parser: parse error at or near "1000" david=> revoke all on t from '1000'; ERROR: parser: parse error at or near "'" david=> revoke all on t from "1000"; ERROR: aclparse: non-existent user "1000" Is there way, how to revoke rights from user with uid = 1000 ? I can create new user with uid = 1000, then revoke rights and drop user, but this is too complex for me ... thanks for any help, -- * David Sauer, student of Czech Technical University * electronic mail: davids@orfinet.cz (mime compatible)
В списке pgsql-sql по дате отправления: