Home » RDBMS Server » Security » grant create session VS grant connect
grant create session VS grant connect [message #223107] Wed, 07 March 2007 10:09 Go to next message
Messages: 1
Registered: March 2007
Junior Member

After a new user is created the user must be given privilege to create session/ connect to oracle database.

Could anyone please explain me the difference between the two of the following:

SQL> grant connect to adbase;


SQL> grant create session to adbase;

My sincere thanks for taking the pains to explain me the difference.
Re: grant create session VS grant connect [message #223109 is a reply to message #223107] Wed, 07 March 2007 10:10 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
CONNECT is a role.
CREATE session is a privilege.
Depending on your version, CONNECT role may have a set of privs granted to it by default.
Previous Topic: Is there a role defined for the following actions?
Next Topic: Oracle users in third-party LDAP
Goto Forum:

Current Time: Tue May 21 11:29:41 CDT 2024