Skip to end of metadata
Go to start of metadata

Description

If a customer is trying to add users to the Loftware Schema within the Oracle 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;
 

Article Number

2015067

Versions

All versions of the Oracle Connector.

Environment

All supported installation environments.