This discussion is archived
1 Reply Latest reply: Mar 25, 2013 11:30 PM by yoonas RSS

DBA privelage

bethebest Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points