Cannot log in to sqlplus: user lacks CREATE SESSION privilege
- Article Type: General
- Product: Aleph
A certain user cannot log in to SQL plus. This is seen when trying to log in:
SQL*Plus: Release 188.8.131.52.0 - Production on Thu Dec 4 15:07:04 2014
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ORA-01045: user XXX01 lacks CREATE SESSION privilege; logon denied
The user may be missing the ALEPH_SCHEMA role.
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