RE: REVOKE problem
Posted in 2000
Watson, Paul — — source: Informix-list mailing list archive (1991-1998)
> To: informix-list@iiug.org
> Subject: REVOKE problem
>
>
> SXMgdGhlcmUgYW55IHdheSBmb3IgREJBIHRvIHJldm9rZSBwcml2aWxlZ2VzIG
> dyYW50ZWQg
> YnkgYW5vdGhlciB1c2VyPw0KSU5GT1JNSVggREJBIGNhbiBncmFudCBwcml2aW
> xlZ2VzIHRv
> IG9uZSB1c2VyL3JvbGUgZnJvbSBhbm90aGVyOg0KDQogICAgR1JBTlQgc29tZX
> RoaW5nIE9O
^^^^^^^^^^^^
Change this to RWin98IE5O
> 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?
>