Re: Table Privilege Losses

I think the solution I presented in my last note may have been a little misleading, so I thought I should pass on the details I have found out since then. If you grant DBA privileges to another userid from the informix userid and then grant other users privileges from the userid with DBA privileges, getting rid of the non-informix DBA userid will _not_ revoke the privileges granted to the others from that userid. We had just been giving our System Administrators the ability to grant access for others using "WITH GRANT OPTION" on the GRANT statement, so if we revoked the System Administrators privileges, all the users he/she had GRANTed to had their privileges revoked also. I hope this all makes sense and is helpful to someone. Regards, Cathy J. Senft Internet: cjsenft@lexmark.com Lexmark International, Inc. Phone: (606) 232-7194 740 New Circle Rd. NW Fax: (606) 232-2177 Lexington, KY 40511-1876