What permissions are required when setting up an Oracle Database for Artifactory?

When you are setting up a new Oracle database for Artifactory to use, Artifactory requires RESOURCE, CONNECT, CREATE SEQUENCE and ALTER privileges.

Here is an example of how we create it it on our testing environments:

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;

ALTER USER artifactory QUOTA UNLIMITED ON USERS;