ORA-01045: user USERNAME lacks CREATE SESSION privilege; logon denied
Oracle user is missing the Create Session privilege or Connect role.
When creating a monitoring user for your Oracle Database, the account should have the privileges to connect data from the database. The following privilege is required:
CREATE SESSION
— allows an account to connect to a database.CONNECT
role which includes the CREATE SESSION
privilege could be granted to the user).Connect to your Oracle Database — use Oracle account with the SYSDBA
privilege, for example:
OracleUser as sysdba
Enter account password.
Either
- OR -
CREATE USER <account_name> IDENTIFIED BY PASSWORD;
CREATE SESSION
system privilege to that account. For that, execute:GRANT CREATE SESSION TO <account_name>;
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center