【oracle】oracle数据库授权视图访问权限

–创建pathview用户
create user pathview identified by pathview;

–授权连接 授予连接权限、清除默认角色权限、授予创建会话权限
GRANT “CONNECT” TO pathview ;
ALTER USER pathview DEFAULT ROLE NONE;
GRANT CREATE SESSION TO pathview ;

–授权视图查询权限
GRANT SELECT ON HIS_V_BLPath TO pathview ;

–授权执行存储过程【inf_pi_update_user_status】和【inf_pi_add_user】执行权限
grant execute on inf_pi_update_user_status to pathview;
grant execute on inf_pi_add_user to pathview;

–调用方式
call inf_pi_update_user_status（4544,0）;

• 显示效果

SQL> set serveroutput on;
SQL> call  inf_pi_update_user_status(206832,0);
 
call  inf_pi_update_user_status(206832,0)
 
ORA-06576: not a valid function or procedure name
 #--调用要加创建的用户名称
SQL> call  user001.inf_pi_update_user_status(206832,0);
 
Method called
 
SQL>