AI Docs

What permissions does Certero for Oracle need to perform an inventory of an Oracle Database?

2 min read

certero logo_cropped_png-01 1.png

The following Oracle SQL scripts can be used to create an Oracle User credential in databases with the appropriate permissions required to perform an inventory. Note there are two scripts, depending on which Certero for Oracle module you have.

Certero for Oracle: Database & Middleware
Certero for Oracle: E-Business Suite

For both these modules, use the version of the "CREATE_USER as at YYYY-MM-DD.txt" script attached to this article to create the user credential. This script will:

  • Create the user and set a password

  • Check the version of Oracle Database

  • Assign the relevant permissions to the user

N.B. the script may fail to assign permissions to certain tables. This is because these tables will only exist if a feature has been used.

At the top of the script is the following section

  • db_user VARCHAR2(30) := ' CERTERO';

  • db_pwd VARCHAR2(30) := ' Password123'

Please replace CERTERO and Password123 within the example SQL script with a username and password suitable for your organization.

Certero for Oracle: E-Business Suite

The second GRANT_USER_EBS.txt script is only applicable to the E-Business Suite (EBS) module of Certero for Oracle. This script should be run AFTER running the "CREATE_USER as at YYYY-MM-DD.txt" script above and it will grant select permissions to the relevant EBS tables.

As above, amend the following section at the top of the script with the same user as used in the "CREATE_USER as at YYYY-MM-DD.txt" script.

db_user VARCHAR2(30) := ' CERTERO';

If you need assistance with the use of these scripts, simply raise a service request (ticket) via our Help Desk.

CREATE_USER script updated

Resources: