如何在Oracle 11g中创建用户并授予权限
问题描述：
有人可以建议我如何在Oracle 11g中创建用户，并且仅授予该用户仅执行一个特定存储过程和该过程中的表的权限.
Can someone advise me on how to create a user in Oracle 11g and only grant that user the ability only to execute one particular stored procedure and the tables in that procedure.
我不太确定该怎么做！
答
以SYSTEM身份连接.
Connect as SYSTEM.
CREATE USER username IDENTIFIED BY apassword;
GRANT CONNECT TO username;
GRANT EXECUTE on schema.procedure TO username;
您可能还需要:
GRANT SELECT [, INSERT] [, UPDATE] [, DELETE] on schema.table TO username;
该过程使用哪个表.