REVOKE

Posted in 1994

Topics: Server Administration, Security, Permissions & Auditing, Migration, Import/Export & Data Conversion

Brian Girard — Fri, 13 May 1994 22:40:19 GMT — source: Informix-list mailing list archive (1991-1998)

Hello fellow informix users: I am having great trouble with using the revoke command. Every so often a user will "accidently" remove a row(s) and I must unload and load from back- up. This is ok if the incident is discovered relatively soon. But to combat this problem, I am trying to revoke all table priviledges except for update. I have dba priviledges and tried this to no avail: revoke delete,alter,index, on clients from brian I went in as user brian (who has connect priviledges only) and I was still able to delete rows?? We are using Informix 2.10.03f on SCO sysV r3.2.4 with MPX 3.0 Any help will be gratefully apreciated. Thank you. Brian ------------------------------------------------------------------------------ Brian Girard voice: (619)755-0239 Systems Support fax: (619)755-0916 Brandes Investment Partners Email: bgirard@cts.com