restrict access for an user doesn't work, again
Posted in 1999
georges Chaleunsinh — — source: Informix-list mailing list archive (1991-1998)
hi,
I fixed partially my problem. before granting select to the user, I have to
revoke all on this table frompublic. But it doesn't work when the table
belongs to another user although I use Informix id.
I'm using IUS 9.14.UC3 on solaris 2.5.1
Suppose we have three ids informix, visitor who can just select table and
the table's owner O.
O create a table with this request: create table test (foo interger);
Oddly Informix can't change the privilege on the table test
visitor have the connect privilege.
O have the resource privilege.
Using this request by Informix doesn't work:
REVOKE ALL ON test FROM public;
GRANT SELECT ON test TO visitor;
I need to be O so that request works.
Is it normal?
thanks for your help.
georges