REVOKE problem

Posted in 2000

Topics: Server Administration, Security, Permissions & Auditing

Leonid Belov — Wed, 25 Oct 2000 11:26:24 -0300 — source: Informix-list mailing list archive (1991-1998)

Is there any way for DBA to revoke privileges granted by another user? INFORMIX DBA can grant privileges to one user/role from another: GRANT something ON object TO user AS grantor but he cannot revoke privileges he granted this manner. Statement REVOKE something ON object FROM user AS grantor gives a syntax error. Of course I can perform DELETE FROM systabauth WHERE ... but I'm afraid that such method is unsafe. Any help would by appreciated. Leonid ------------- To INFORMIX: why GRANT is unrevertable?

↪ replying to Leonid Belov

Sergey E. Volkov — Wed, 25 Oct 2000 19:22:55 +0400 — source: Informix-list mailing list archive (1991-1998)

Valid syntax is ' REVOKE something ON object FROM user '. DBA may revoke privilege granted by any user. Leonid Belov <white@science-ltd.ru> ''''' ' ''''''''':39F6ED90.252CE146@science-ltd.ru... > Is there any way for DBA to revoke privileges granted by another user? > INFORMIX DBA can grant privileges to one user/role from another: > > GRANT something ON object TO user AS grantor> > but he cannot revoke privileges he granted this manner. Statement > > REVOKE something ON object FROM user AS grantor> > gives a syntax error. Of course I can perform > > DELETE FROM systabauth WHERE ...> > but I'm afraid that such method is unsafe. > > Any help would by appreciated. > > Leonid > > ------------- > To INFORMIX: why GRANT is unrevertable? > > >

↪ replying to Sergey E. Volkov

l_white@my-deja.com — Thu, 26 Oct 2000 06:02:28 GMT — source: Informix-list mailing list archive (1991-1998)

In article <8t6u9q$c431@www.informix.com>, "Sergey E. Volkov" <sve@raiden.bancorp.ru> wrote: > Valid syntax is ' REVOKE something ON object FROM user '. > > DBA may revoke privilege granted by any user. ISAM error: record not found > > Leonid Belov <white@science-ltd.ru> ''''' ' > ''''''''':39F6ED90.252CE146@science-ltd.ru... > > Is there any way for DBA to revoke privileges granted by another user? > > INFORMIX DBA can grant privileges to one user/role from another: > > > > GRANT something ON object TO user ASgrantor > > > > but he cannot revoke privileges he granted this manner. Statement > > > > REVOKE something ON object FROM user ASgrantor > > > > gives a syntax error. Of course I can perform > > > > DELETE FROM systabauth WHERE ...> > > > but I'm afraid that such method is unsafe. > > > > Any help would by appreciated. > > > > Leonid > > > > ------------- > > To INFORMIX: why GRANT is unrevertable? Sent via Deja.com http://www.deja.com/ Before you buy.