What Permissions Are Required for an Oracle Database?
Artifactory needs some specific permissions in order to successfully connect to an Oracle database.
Usually it’s easiest to grant full access, the permissions outlined below are the ones the application needs to function:
CREATE USER artifactory IDENTIFIED BY password
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";
GRANT "RESOURCE" TO artifactory;
GRANT "CONNECT" TO artifactory;
GRANT CREATE SEQUENCE TO artifactory;
GRANT CREATE SESSION TO artifactory;
ALTER USER artifactory QUOTA UNLIMITED ON USERS;