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;