OraFAQ Forum: Security » grant create session VS grant connect

Home » RDBMS Server » Security » grant create session VS grant connect

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

grant create session VS grant connect [message #223107]

Wed, 07 March 2007 10:09

adbase
Messages: 1
Registered: March 2007
Location: KOLKATA, INDIA

Junior Member

Hi,

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;

AND

SQL> grant create session to adbase;

My sincere thanks for taking the pains to explain me the difference.

Report message to a moderator

Re: grant create session VS grant connect [message #223109 is a reply to message #223107]

Wed, 07 March 2007 10:10

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic:	Is there a role defined for the following actions?
Next Topic:	Oracle users in third-party LDAP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 17 13:16:43 CST 2026