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;