ORA-01045 user lacks CREATE SESSION When Create Session Privilege Is Granted To a Role

(Doc ID 1970354.1)

Last updated on NOVEMBER 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.


- ORA-01045: user <username> lacks CREATE SESSION privilege; logon denied

- The CREATE SESSION privilege is granted to a role the user has been granted

- The role is expected to be enabled upon login but apparently it is not.



This typically happens after an upgrade to


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms