oracle开放查询表权限_oracle 表权限分配

grant xxx权限 on Table to USER

grant select,insert,update,delete,all on 表名 to 用户名

例如：将test表的查询权限赋予tom这个用户

grant select on test to tom

---------------------------------------

select 'GRANT SELECT ON ' || table_name || ' to user1;' from user_tables

grant select,insert,update,delete,all on 表名 to 用户

比如：授查询sys_users表的查询权限给jwwl用户

grant select on sys_users to jwwl

-- 创建用户

create user YG identified by YG;

-- 用户授权

grant create session, connect, resource to YG;

--ORACLE函数授权给所有用户

GRANT execute on comm.fun_getagebybirthday TO yg;

--oracle给表显式授权

grant select on MEDREC.pat_visit to yg;