Re: Revoking Permission

Posted in 2000

Obnoxio The Clown — Thu, 02 Mar 2000 19:21:01 GMT — source: Informix-list mailing list archive (1991-1998)

From: fsabile@my-deja.com > >I need help on permissions. Our system grants >connect to public. I want public to have access >to all the tables except for one problematic user. > >I tried revoke connect from username but because >public has connect, the user can still access >tables. I tried REVOKE ALL on tablename FROM >username and still didn't work. > >Is there a way not to give a unix user access to >my database even though public has connect grants? Nope. You;d have to revoke everything from everyone and then grant to (everyone - painful user) explicitly. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com