Re: Table privileges
Posted in 1998
John Harman — — source: Informix-list mailing list archive (1991-1998)
On 18 May 1998, Dirk Moolman wrote:
> Hi, I have not done this before. I am trying to revoke all rights from
> public on specific tables and then to grant select rights only, but for
> some reason the privileges stay active (are not revoked) on these tables -
>
> "revoke all on <tabname> from public"
> "grant select on <tabname> to public"
>
> The commands are executed successfully, but when I do a table info in
> dbaccess afterwards, "public" still has full table rights - update, insert,
> delete, etc.
When you find out, let me know. I'm having the same problem.
John