1

What is the privilege my user requires to be able to grant the following privileges

CONNECT, RESOURCE and CREATE SESSION

to OTHER users in Oracle 11g?

Improve this question
2
  • connect and create session is the same thing. There is no need to grant both.
    – user1822
    Dec 7, 2014 at 22:49
  • 1
    @a_horse_with_no_name: no, that is wrong, they are not the same thing. CONNECT is a role that has granted the system privilege CREATE SESSION.
    – miracle173
    Dec 7, 2014 at 23:14

1 Answer 1

Reset to default
3

If a system privilege is granted with ADMIN OPTION to a user, this user can grant this system privileges to other users, e.g. after

GRANT CREATE SESSION TO SCOTT WITH ADMIN OPTION

Scott is able to grant CREATE TABLE to other users. He is also able to grant CREATE TABLE to other users WITH GRANT OPTION. WITH GRANT OPTION works for roles too.

An object privileges (like a select on a table) must be granted WITH GRANT OPTION to a user to grant it to another user.

GRANT SELECT ON HR.EMPLOYEES TO SCOTT WITH GRANT OPTION

This can be found in the SQL Language Reference

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.