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

How to create a user in Oracle 11g and grant permissions(如何在 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.

我真的不知道该怎么做！

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;

到过程使用的任何表.

这篇关于如何在 Oracle 11g 中创建用户并授予权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！