English

Error: ORA-01045: user GUEST lacks CREATE SESSION privilege

Error Message

C:\>sdelayer -o describe -u guest -p guest
ArcSDE 8.0.1
Layer Administration Utility
-----------------------------------------------------
Error: Underlying DBMS error (-51).
Error: Could not create a connection.
Extended DBMS error code: 1045
ORA-01045: user GUEST lacks CREATE SESSION privilege; logon
denied

Cause

The Oracle user lacks the CONNECT role.

Note: the CONNECT role consists of several privileges, one of which is CREATE SESSION.

Solution or Workaround

Grant the CONNECT role to the Oracle user. For example, the sdelayer command (above) will run successfully after the Oracle user named 'guest' is granted the CONNECT role.