Re: SQL grant privileges problem

Colin Mcgrath (colin@scdipc0.ueci.com) wrote: : Hi, : I wanted to revoke certain privileges on a table from a few persons, : but in general allow "public" all privileges. (By Informix's default, : on a NON-ANSI database, public is granted all privs). I'm sure it says this in the manual, but I 'm not sure where: You must revoke all on public and then grant specific priv's on each user. I donb't think there's another way to do this. So, give public the most restrictive priv's and then add to each seperate users priv's. Pain, but required. -- gburnore@garys.arasmith.com ------------------------------------------------------------------------------- How you look depends on where you go. ------------------------------------------------------------------------------- | '۳''''''۳''''''''''''' Gary L. Burnore | '۳''''''۳''''''''''''' Director, Programming & Development | '۳''''''۳''''''''''''' Myers Information Systems, Inc. | '۳''''''۳''''''''''''' | Official Proof of Purchase ===============================================================================