Use the commands below to create an Artifactory user and database with appropriate permissions. Modify the relevant values to match your specific environment:
Creating an Artifactory User and Database
CREATE USER artifactory WITH PASSWORD 'password'; CREATE DATABASE artifactory WITH OWNER=artifactory ENCODING='UTF8'; GRANT ALL PRIVILEGES ON DATABASE artifactory TO artifactory;
Once you have verified that the script is correct, you need to run it to create the database and proceed with configuring the database.
We recommend providing Artifactory with full privileges on the database.