Scribd
Upload
12 views1 page

Database User INFREP9 Permissions

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
12 views1 page

Database User INFREP9 Permissions

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
You are on page 1/ 1

CREATE USER INFREP9 IDENTIFIED BY INFREP9;

GRANT SELECT_CATALOG_ROLE TO INFREP9;


ALTER USER INFREP9 DEFAULT ROLE ALL;
GRANT ALTER SESSION TO INFREP9;
GRANT CREATE MATERIALIZED VIEW TO INFREP9;
GRANT DEBUG CONNECT SESSION TO INFREP9;
GRANT QUERY REWRITE TO INFREP9;
GRANT CREATE ANY MATERIALIZED VIEW TO INFREP9;
GRANT ALTER USER TO INFREP9 WITH ADMIN OPTION;
GRANT CREATE TRIGGER TO INFREP9;
GRANT CREATE PROCEDURE TO INFREP9;
GRANT CREATE SEQUENCE TO INFREP9;
GRANT CREATE TABLE TO INFREP9;
GRANT CREATE SESSION TO INFREP9 WITH ADMIN OPTION;
GRANT CREATE ANY CONTEXT TO INFREP9;
GRANT CREATE PUBLIC SYNONYM TO INFREP9;
GRANT ADVISOR TO INFREP9;
GRANT CREATE TYPE TO INFREP9;
GRANT CREATE VIEW TO INFREP9;
GRANT CREATE SYNONYM TO INFREP9;
GRANT CREATE DATABASE LINK TO INFREP9;
GRANT UNLIMITED TABLESPACE TO INFREP9;
grant connect,resource to INFREP9;
GRANT SYSDBA TO INFREP9;
ALTER USER INFREP9 PROFILE my_profile;

You might also like