Use > Database > Deploying the Oracle Server Database > Manually Creating the Oracle Server Database Schemas > Creating Schema User Permissions

Creating Schema User Permissions

The database administrator should create an Oracle schema user with the database permissions required by the Universal CMDB application.

The following database permissions must be granted to Universal CMDB Oracle schema users. These permissions are also used by the Universal CMDB installer to create a new Oracle user:

  • Roles

    • Connect

  • Privileges

    • CREATE TABLE

    • CREATE VIEW

    • CREATE SEQUENCE

    • CREATE TRIGGER

    • CREATE PROCEDURE

    • UNLIMITED TABLESPACE

    • ALTER USER ${user} DEFAULT ROLE ALL

    • CREATE TYPE

    • EXECUTE ON DBMS_LOB

    • EXECUTE ON DBMS_STATS

Note  

  • Universal CMDB supports any user with higher permissions. For Universal CMDB certification, use an Oracle user that has the exact Oracle permissions described above.

  • The last two permissions (EXECUTE ON DBMS_LOB and EXECUTE ON DBMS_STATS) are granted by default.

Send Help Center feedback