ORA-01045: user SCOTT lacks CREATE SESSION privilege

November 7, 2010 | By

Hi Friends,

This is general error getting from Oracle 10g database. It calls as ORA-01045 that lacking of create session privilege.

Reason of ORA-01045:

From Oracle 10g, connect role doesn’t contain create session privilege.

Solution of ORA-01045:

If you granted connect role to any user and database was upgraded then you should need to give create session privilege explicitly.

Sometime we are getting this same ORA-01045 during datapump usage. Same solution is applying in same condition also.

During database administration, we are getting so many mysterious errors and situation of those errors is unknown. For resolution any ORA ERROR and managing Database, approach database services of DBAMETRIX. You will get maximum benefits in minimum charges.

Thanks and regards,

Dbametrix Remote dba expert team.



Tags: , , , , , , , , ,

Category: blog, blogging, business, database, database services, DBA, oracle 10g dba, oracle dba, remote services, software

Comments are closed.