Revoking Permission

Posted in 2000

Topics: Security, Permissions & Auditing

fsabile@my-deja.com — Thu, 02 Mar 2000 14:23:54 GMT — source: Informix-list mailing list archive (1991-1998)

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? I would appreciate any help you can give me. Thank you in advance. Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to fsabile@my-deja.com

mars1972@my-deja.com — Thu, 02 Mar 2000 16:25:53 GMT — source: Informix-list mailing list archive (1991-1998)

In article <89lthn$i32$1@nnrp1.deja.com>, fsabile@my-deja.com wrote: > 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? > > I would appreciate any help you can give me. > Thank you in advance. > > Sent via Deja.com http://www.deja.com/ > Before you buy. > I believe you'd have to revoke permission from public and grant it to everyone except that person. I could be wrong. Anybody else know of a different way? -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.