关于用户权限设定的问题

amiescort

There is a sample:
GRANT DELETE, SELECT, UPDATE (customer_num, fname, lname)
ON customer TO mary, john

mailtojacky

首先要对用户
grant connect to username
然后
revoke all on tablename  from "public";
最后
grant select on tablename to username as 授权用户

大梦

grant connect to user
user将拥有所有表的权限，因为在grant connect to user的同时，informix已经把all table to public了~~~
grant connect to user可以revoke表的权限from public