Friday, October 30, 2020
dbametrix
More
    Home Oracle DBA Tips ORA-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 -
    dbametrix

    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 -
    dbametrix

    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.

    Thanks and regards,

    Dbametrix Remote dba expert team.

     

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    Identifying important information in Big Data

    The way in which Big Data technologies have evolved in the real word enterprise goes on to show that even technologists and scientists who might have disparaged the word (Big Data) previously

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Recent Comments