如何在 Oracle 11g 中创建用户并授予权限

2021-11-26 00:00:00 oracle11g oracle access-control

有人可以告诉我如何在 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.

我真的不知道该怎么做！

I am not really sure how to do this!

推荐答案

以 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;

到过程使用的任何表.

相关文章