Re: security and users

From: "Ursino, Rich" <RUrsino@Internal.massmutual.com> > >I am looking for documentation on security involved with creating users for >Informix 7.30 and Informix Universal >Server 9.14. I have been to the System Admin class and purchased the >Informix DBA Survival Guide, >but do not find any lengthy or clear dicussion of adding users and >protecting data. >We are a running our systems on an RS6000 AIX 4.3.1 /4.3.2 platform(s). >I am familiar with Oracles and Sybases procedures and am fluent with unix >OS >level secuirty. Well, the simple reason you couldn't find any were that there aren't any... :-) Once the user can access the O/S, all you have to do is grant database and table level access permissions, like: GRANT CONNECT ON mydb TO fred; GRANT SELECT ON mytable TO fred; etc.... HTH. -- Bye now, Obnoxio "The one with the smartest marketing department wins" ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com