[oracle] How to grant "grant create session" privilege?

How to grant the privilege of giving the privilege of creating a session to a user or role in Oracle?

This question is related to oracle

The answer is


grant CREATE SESSION

Ref.. http://ss64.com/ora/grant.html

HTH,

Kent


You can grant system privileges with or without the admin option. The default being without admin option.

GRANT CREATE SESSION TO username

or with admin option:

GRANT CREATE SESSION TO username WITH ADMIN OPTION

The Grantee with the ADMIN OPTION can grant and revoke privileges to other users