Re: Does revoke all from public actually work?

Posted in 1996

Oleg Tretyakov — Thu, 28 Nov 1996 06:47:05 GMT — source: Informix-list mailing list archive (1991-1998)

On 27 Nov 1996 21:38:52 GMT, belakimem@aol.com wrote: >Online Version 5.07.UC1 > >I create a table and revoked all on the table from Public. I also granted >select on the table to public. Yet any user can update the table. > >Does anybody know why ? > >Potential responders, please reply to my email address as well as the >List. Thank You. I think that PUBLIC has DBA privilege in your database. Try REVOKE DBA FROM PUBLIC. Hope this helps. Oleg Tretyakov tov@inist.ru