比如帐户
create user HZ
identified by
default tablespace YDGL
temporary tablespace ROLLTEMP
profile DEFAULT;
-- Grant/Revoke object privileges
grant select on HS_DFLSZ to HZ;
grant select, insert, update, delete, references, alter, index on YYHTJ_TEMP to HZ;
-- Grant/Revoke role privileges
grant connect to HZ;
grant resource to HZ;
-- Grant/Revoke system privileges
grant unlimited tablespace to HZ;
没有给这个号设定select any table系统权限,却能查询我帐号下的所有表.
|