remote dba support
    HomeOracle DBA TipsORA-01045: user SCOTT lacks CREATE SESSION privilege

    ORA-01045: user SCOTT lacks CREATE SESSION privilege

    Hi Friends,

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

    - Advertisement -

    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.

    - Advertisement -

    Sometimes we are getting this same ORA-01045 during datapump usage. The same solution is applying to the same condition also.

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

    When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.

    This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.


    - Advertisement -
    - Advertisment -
    remote dba services

    Most Popular