Cannot log in to sqlplus: user lacks CREATE SESSION privilege

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph

Problem Symptoms:
A certain user cannot log in to SQL plus. This is seen when trying to log in:

>s+ xxx01

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Dec 4 15:07:04 2014

Copyright (c) 1982, 2008, Oracle. All rights reserved.

ERROR:
ORA-01045: user XXX01 lacks CREATE SESSION privilege; logon denied

Cause:
The user may be missing the ALEPH_SCHEMA role.

Resolution:
To check if the user is missing the ALEPH_SCHEMA role:
>sqlplus ALEPH_DBA/[ALEPH_DBA password]
SQL>select * from DBA_ROLE_PRIVS where grantee='XXX01' and GRANTED_ROLE='ALEPH_SCHEMA';

If there are no results, you can fix this with the following command:

SQL>grant ALEPH_SCHEMA to XXX01;

Article last edited: 12/31/2014