Re: Revoke permission

Cheryl Kendricks wrote: > > Yes, I did notice in books that DBA has grant authorization, create/drop > anything. Yet, NO revoke at table level. Only the owner of the table can > REVOKE. I think INFORMIX needs to change THIS!!!!!! If i remember > correctly in DB2 with DBA authority you can do it all. If a shop is set > up correctly a database should only have two DBA's at most (one for > backup). > > My work around now is to create the tables NOT with my ID or my > production operators administration ID (they normally run the major long > DBA functions and production posting process),but an ID that is consider to belong to the > DBA. Presently they are being created with the operations admin ID, It can > do more on the system then I need authority to do or want to do. Yet I > have to have them perform the tables revokes since they own the tables. > > How about it INFORMIX!!!! ALLOW the DBA to REVOKE table level permissions, > even if the DBA is NOT the table level owner or grantor of the permission! > ------------------------------------------------------------------------- > Cheryl Kendricks > Internet: cherylk@spamis.jcdc.doleta.gov > OR > cherylk@prod1.jcdc.doleta.gov > OR > kendric@gwysmtp.jcdc.doleta.gov > DTSI, Inc. Voice: 1-800-598-5008 > Database Administrator - DOL Job Corps San Marcos, Texas > ------------------------------------------------------------------------> > On Fri, 12 Apr 1996, Mike Segel wrote: > > > Cheryl, > > > > Are you asking the following: > > If the owner or informix grants me DBA privs, why cant I revoke other > > privs from the database? > > > > -Mikey > > There is a Feature Request at Informix Support Munich, that I ask y'all to join in, to produce some pressure on this ! Tanks Andreas