---
title: "What permissions does Certero for Oracle need to perform an inventory of an Oracle Database?"
canonical: "https://ai-docs.certero.com/space/CUP/118918514/What%20permissions%20does%20Certero%20for%20Oracle%20need%20to%20perform%20an%20inventory%20of%20an%20Oracle%20Database%3F"
format: markdown
---
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) := ' <span style="color: #4c9aff">CERTERO</span>';
- db_pwd VARCHAR2(30) := ' <span style="color: #4c9aff">Password123</span>'

Please replace <span style="color: #4c9aff">CERTERO </span>and <span style="color: #4c9aff">Password123 </span>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) := ' <span style="color: #4c9aff">CERTERO</span>'; 

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

CREATE_USER script updated 9/27/2021

**Resources:**

- 
-