How can I create a user in Oracle 11g?

1142720 pts.
Tags:
Oracle
Oracle 11g
I need some help! I'm trying to create a user in Oracle 11g and only grant them the ability to execute one stored procedure, along with the tables in the procedure. Is that possible? If so, what's the process to do it?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

To create the user, you would need to do something like this:

create user user_name identified by user_password;
grant create session to user_name;
grant resource to user_name;

As for the permissions, Oracle runs stored procedures with the privileges of the procedure’s owner, so you only need to grant the privilege to execute the procedure, and it will have access to the tables referenced in its code.

grant execute on your_procedure to user_name;

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: