Create Oracle Admin Users with Limited Privileges - Intergraph Smart Engineering Manager - 3.0 - Installation & Upgrade - Hexagon

When working on an Oracle platform, you can create a database user with limited privileges which allow that user to perform Smart Engineering Manager procedures such as creating sites and plants, and associating applications.

You need to know the Oracle instance's system username and password to be able to create the user or role.

Create an Admin User (USER_ADMIN)

The following script can be run to create a user with a minimum set of privileges.

CREATE USER USER_ADMIN

IDENTIFIED BY USER_ADMIN

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

------- 2 Roles for USER_ADMIN

GRANT SELECT_CATALOG_ROLE TO USER_ADMIN WITH ADMIN OPTION;

GRANT EXECUTE_CATALOG_ROLE TO USER_ADMIN WITH ADMIN OPTION;

ALTER USER USER_ADMIN DEFAULT ROLE ALL;

-------- 14 System Privileges for USER_ADMIN

GRANT CREATE TRIGGER TO USER_ADMIN WITH ADMIN OPTION;

GRANT CREATE DATABASE LINK TO USER_ADMIN WITH ADMIN OPTION;

GRANT DROP USER TO USER_ADMIN WITH ADMIN OPTION;

GRANT CREATE SEQUENCE TO USER_ADMIN WITH ADMIN OPTION;

GRANT CREATE CLUSTER TO USER_ADMIN WITH ADMIN OPTION;

GRANT ALTER SESSION TO USER_ADMIN WITH ADMIN OPTION;

GRANT CREATE PROCEDURE TO USER_ADMIN WITH ADMIN OPTION;

GRANT CREATE VIEW TO USER_ADMIN WITH ADMIN OPTION;

GRANT CREATE USER TO USER_ADMIN;

GRANT CREATE SESSION TO USER_ADMIN WITH ADMIN OPTION;

GRANT CREATE SYNONYM TO USER_ADMIN WITH ADMIN OPTION;

GRANT ALTER USER TO USER_ADMIN WITH ADMIN OPTION;

GRANT CREATE TABLE TO USER_ADMIN WITH ADMIN OPTION;

GRANT ALTER SYSTEM TO USER_ADMIN WITH ADMIN OPTION;

ALTER USER USER_ADMIN QUOTA UNLIMITED ON USERS;