CREATE USER DOM_INFA IDENTIFIED BY DOM_INFA;
GRANT SELECT_CATALOG_ROLE TO DOM_INFA;
ALTER USER DOM_INFA DEFAULT ROLE ALL;
GRANT ALTER SESSION TO DOM_INFA;
GRANT CREATE MATERIALIZED VIEW TO DOM_INFA;
GRANT DEBUG CONNECT SESSION TO DOM_INFA;
GRANT QUERY REWRITE TO DOM_INFA;
GRANT CREATE ANY MATERIALIZED VIEW TO DOM_INFA;
GRANT ALTER USER TO DOM_INFA WITH ADMIN OPTION;
GRANT CREATE TRIGGER TO DOM_INFA;
GRANT CREATE PROCEDURE TO DOM_INFA;
GRANT CREATE SEQUENCE TO DOM_INFA;
GRANT CREATE TABLE TO DOM_INFA;
GRANT CREATE SESSION TO DOM_INFA WITH ADMIN OPTION;
GRANT CREATE ANY CONTEXT TO DOM_INFA;
GRANT CREATE PUBLIC SYNONYM TO DOM_INFA;
GRANT ADVISOR TO DOM_INFA;
GRANT CREATE TYPE TO DOM_INFA;
GRANT CREATE VIEW TO DOM_INFA;
GRANT CREATE SYNONYM TO DOM_INFA;
GRANT CREATE DATABASE LINK TO DOM_INFA;
GRANT UNLIMITED TABLESPACE TO DOM_INFA;
grant connect,resource to DOM_INFA;
GRANT SYSDBA TO DOM_INFA;
CREATE PROFILE my_profile LIMIT PASSWORD_LIFE_TIME 30;
ALTER USER DOM_INFA PROFILE my_profile;
ALTER PROFILE my_profile LIMIT PASSWORD_LIFE_TIME UNLIMITED;
alter user hr account unlock;
alter user hr identified by hr;