Scribd
Upload
7 views1 page

User Syntax-Domain

domain

Uploaded by

onkarbalgude
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
7 views1 page

User Syntax-Domain

domain

Uploaded by

onkarbalgude
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

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;

You might also like