List/Grant/Revoke Oracle Privileges(二)
,可以执行:
grant execute on Find_Value to smithj;
把Funciton Find_Value的执行权限付给所有用户,可以执行:
grant execute on Find_Value to public;
Revoke Privileges on Functions/Procedures
针对Functions/Procedures的撤权。
语法:
revoke execute on object from user;
撤销anderson针对Find_Value Funciton的执行权限,可以执行:
revoke execute on Find_Value from anderson;
如果你赋权过所有用户,现在想撤销,可以执行:
revoke execute on Find_Value from public;