Query to create Repository User in Oracle

–Create  a new tablespace:

DROP TABLESPACE infa_repo_dev_ts INCLUDING CONTENTS;

CREATE TABLESPACE infa_repo_dev_ts DATAFILE SIZE 50 M AUTOEXTEND ON NEXT 10 M MAXSIZE UNLIMITED FORCE LOGGING ONLINE FLASHBACK OFF;

–Create the infa_repo_dev database user:

DROP USER infa_repo_dev CASCADE;

CREATE USER infa_repo_dev IDENTIFIED BY DB105you DEFAULT TABLESPACE infa_repo_dev_ts TEMPORARY TABLESPACE temp QUOTA 0 ON USERS QUOTA 0 ON SYSTEM QUOTA 0 ON SYSAUX QUOTA UNLIMITED ON infa_repo_dev_ts;

–Grant necessary privileges and roles to your infa_repo_dev database user:

GRANT CONNECT, RESOURCE TO infa_repo_dev;

GRANT CREATE TABLE TO infa_repo_dev;

GRANT CREATE VIEW TO infa_repo_dev;

GRANT CREATE SEQUENCE TO infa_repo_dev;

GRANT CREATE SESSION TO infa_repo_dev;

GRANT CREATE SYNONYM TO infa_repo_dev;