1 Reply Latest reply: Mar 26, 2013 1:30 AM by yoonas RSS

    DBA privelage

    beyourbest
      I set up a user as an admin in XE, this is what it says in App Express...

      "Specify if this user should have workspace administrator privileges. Administrators are given access to all components. Additionally, they can also manage user accounts, groups, and development services. Components may not be available if they are switched off by Instance Administrators."


      ...but I get this error when setting up a users from ODI...

      oracle.odi.setup.RepositorySetupException: Error while updating Schema Version Registry Entry for ODI. Check if user ODI_MASTER has DBA permissions.
           at oracle.odi.setup.support.SchemaVersionUtil.setComponentInvalid(SchemaVersionUtil.java:223)
           at oracle.odi.setup.support.MasterRepositorySetupImpl.createMasterRepository(MasterRepositorySetupImpl.java:239)
           at oracle.odi.ui.gallery.support.MasterCreateRepositoryPage.invoke(MasterCreateRepositoryPage.java:226)
           at oracle.odi.ui.gallery.support.AbstractMasterRepositoryWizard$2.run(AbstractMasterRepositoryWizard.java:156)
           at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:656)
           at java.lang.Thread.run(Thread.java:662)
      Caused by: java.sql.SQLRecoverableException: Closed Connection
           at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:5470)
           at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1672)
           at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:446)
           at oracle.ias.version.SchemaVersion.executeVersionQuery(SchemaVersion.java:2432)
           at oracle.ias.version.SchemaVersion.hasRegistryEntry(SchemaVersion.java:2025)
           at oracle.ias.version.SchemaVersion.setComponentInvalid(SchemaVersion.java:1943)
           at oracle.odi.setup.support.SchemaVersionUtil.setComponentInvalid(SchemaVersionUtil.java:221)
           at oracle.odi.setup.support.MasterRepositorySetupImpl.createMasterRepository(MasterRepositorySetupImpl.java:239)
           at oracle.odi.ui.gallery.support.MasterCreateRepositoryPage.invoke(MasterCreateRepositoryPage.java:226)
           at oracle.odi.ui.gallery.support.AbstractMasterRepositoryWizard$2.run(AbstractMasterRepositoryWizard.java:156)
           at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
           ... 1 more


      ...is there somewhere else I can change a user to grant "DBA" permission..
        • 1. Re: DBA privelage
          yoonas
          Hi,

          To grant dba role to a user , start sqlplus session and issue
          Grant dba to <user>;
          http://www.orafaq.com/wiki/Oracle_database_Security_FAQ#How_does_one_create.2C_manage_and_drop_database_users.3F

          Regards
          Yoonas