Permissions to Grant Users Without Having to Grant Them SYSDBA for Oracle Connector

Description

If a customer is trying to add users to the Loftware Schema within the Oracle Connector See Loftware Connector. and is unable to grant them SYSDBA privileges, below are all the permissions available within Oracle:

Note: You can remove the CREATE USER privilege if that isn’t required.

 CREATE ROLE Loftware_User_Role;
 GRANT AUDIT ANY TO Loftware_User_Role;
 GRANT RESUMABLE TO Loftware_User_Role;
 GRANT ANALYZE ANY TO Loftware_User_Role;
 GRANT CREATE ROLE TO Loftware_User_Role;
 GRANT CREATE TYPE TO Loftware_User_Role;
 GRANT EXECUTE ANY TYPE TO Loftware_User_Role;
 GRANT CREATE USER TO Loftware_User_Role;
 GRANT CREATE VIEW TO Loftware_User_Role;
 GRANT CREATE TABLE TO Loftware_User_Role;
 GRANT ALTER SESSION TO Loftware_User_Role;
 GRANT QUERY REWRITE TO Loftware_User_Role;
 GRANT CREATE CLUSTER TO Loftware_User_Role;
 GRANT CREATE LIBRARY TO Loftware_User_Role;
 GRANT CREATE PROFILE TO Loftware_User_Role;
 GRANT CREATE SESSION TO Loftware_User_Role;
 GRANT CREATE SYNONYM TO Loftware_User_Role;
 GRANT CREATE TRIGGER TO Loftware_User_Role;
 GRANT CREATE OPERATOR TO Loftware_User_Role;
 GRANT CREATE SEQUENCE TO Loftware_User_Role;
 GRANT CREATE SNAPSHOT TO Loftware_User_Role;
 GRANT CREATE ANY INDEX TO Loftware_User_Role;
 GRANT CREATE DIMENSION TO Loftware_User_Role;
 GRANT CREATE INDEXTYPE TO Loftware_User_Role;
 GRANT CREATE PROCEDURE TO Loftware_User_Role;
 GRANT EXECUTE ANY PROCEDURE TO Loftware_User_Role;
 GRANT INSERT ANY TABLE TO Loftware_User_Role;
 GRANT SELECT ANY TABLE TO Loftware_User_Role;
 GRANT UPDATE ANY TABLE TO Loftware_User_Role;
 GRANT ON COMMIT REFRESH TO Loftware_User_Role;
 GRANT GLOBAL QUERY REWRITE TO Loftware_User_Role;
 GRANT CREATE PUBLIC SYNONYM TO Loftware_User_Role;
 GRANT DROP PUBLIC SYNONYM TO Loftware_User_Role;
 GRANT DEBUG CONNECT SESSION TO Loftware_User_Role;
 GRANT FORCE ANY TRANSACTION TO Loftware_User_Role;
 GRANT SELECT ANY DICTIONARY TO Loftware_User_Role;
 GRANT DROP PUBLIC DATABASE LINK TO Loftware_User_Role;
 GRANT ADMINISTER DATABASE TRIGGER TO Loftware_User_Role;
 GRANT CREATE PUBLIC DATABASE LINK TO Loftware_User_Role;