Scribd
Upload
4 views

knowledge_base_SQLT_USER_ROLE

Uploaded by

kapil Jadhav
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
4 views

knowledge_base_SQLT_USER_ROLE

Uploaded by

kapil Jadhav
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/ 2

CREATE ROLE "SQLT_USER_ROLE";

GRANT ADVISOR TO "SQLT_USER_ROLE";

GRANT EXECUTE ON "SYS"."DBMS_METADATA" TO "SQLT_USER_ROLE";


GRANT INSERT ON "SQLTXPLAIN"."TRCA$_PLAN_TABLE"; TO "SQLT_USER_ROLE";
GRANT UPDATE ON "SQLTXPLAIN"."TRCA$_TABLES" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."TRCA$_TABLES" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_STATTAB" TO "SQLT_USER_ROLE";
GRANT INSERT ON "SQLTXPLAIN"."SQLT$_STATTAB" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_STGTAB_SQLPROF" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLI$_FILE"; TO "SQLT_USER_ROLE";
GRANT INSERT ON "SQLTXPLAIN"."SQLI$_FILE"; TO "SQLT_USER_ROLE";
GRANT UPDATE ON "SQLTXPLAIN"."SQLI$_DB_LINK" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLI$_DB_LINK" TO "SQLT_USER_ROLE";
GRANT INSERT ON "SQLTXPLAIN"."SQLI$_DB_LINK" TO "SQLT_USER_ROLE";
GRANT DELETE ON "SQLTXPLAIN"."SQLI$_DB_LINK" TO "SQLT_USER_ROLE";
GRANT UPDATE ON "SQLTXPLAIN"."SQLT$_SQL_STATEMENT" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_SQL_STATEMENT" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_SQL_PLAN_TABLE"; TO "SQLT_USER_ROLE";
GRANT INSERT ON "SQLTXPLAIN"."SQLT$_SQL_PLAN_TABLE"; TO "SQLT_USER_ROLE";
GRANT DELETE ON "SQLTXPLAIN"."SQLT$_SQL_PLAN_TABLE"; TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXADMIN"."SQLT$_DBA_ALL_TABLES_V" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXADMIN"."SQLT$_GV$CELL_STATE_V" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXADMIN"."SQLT$_LOG_V" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_DBA_TAB_STATS_VERSIONS" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_DBA_IND_STATS_VERSIONS" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_GV$CELL_STATE"; TO "SQLT_USER_ROLE";
GRANT WRITE ON DIRECTORY "SQLT$STAGE"; TO "SQLT_USER_ROLE";
GRANT READ ON DIRECTORY "SQLT$STAGE"; TO "SQLT_USER_ROLE";
GRANT SELECT ON "SYS"."TRCA$_LOG_V" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_DBA_CONSTRAINTS" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_DBA_TABLESPACES" TO "SQLT_USER_ROLE";
GRANT UPDATE ON "SQLTXPLAIN"."SQLT$_DBA_OBJECTS" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_DBA_OBJECTS" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_DBA_HIST_SQLSTAT" TO "SQLT_USER_ROLE";
GRANT UPDATE ON "SQLTXPLAIN"."SQLT$_DBA_TABLES" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_DBA_TABLES" TO "SQLT_USER_ROLE";
GRANT UPDATE ON "SQLTXPLAIN"."SQLT$_DBA_OBJECT_TABLES" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_DBA_OBJECT_TABLES" TO "SQLT_USER_ROLE";
GRANT UPDATE ON "SQLTXPLAIN"."SQLT$_DBA_INDEXES" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_DBA_INDEXES" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$A" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$C" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$D" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$E"; TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$H" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$I" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$M" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$R" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$S" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."SQLT$T" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."TRCA$G" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."TRCA$P" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."TRCA$T" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."TRCA$I" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."TRCA$E"; TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."TRCA$R" TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "SQLTXADMIN"."TRCA$X" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXADMIN"."TRCA$_PROGRESS_V" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXADMIN"."TRCA$_PURGE_CANDIDATE_V" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXADMIN"."TRCA$_SQL_V" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXADMIN"."TRCA$_GROUP_V" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLG$_TEMP" TO "SQLT_USER_ROLE";
GRANT INSERT ON "SQLTXPLAIN"."SQLG$_TEMP" TO "SQLT_USER_ROLE";
GRANT DELETE ON "SQLTXPLAIN"."SQLG$_TEMP" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLG$_PIVOT" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_PLAN_EXTENSION" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_LOG" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_METADATA" TO "SQLT_USER_ROLE";
GRANT INSERT ON "SQLTXPLAIN"."SQLT$_METADATA" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."SQLT$_FND_HISTOGRAM_COLS" TO "SQLT_USER_ROLE";
GRANT INSERT ON "SQLTXPLAIN"."SQLT$_FND_HISTOGRAM_COLS" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."TRCA$_TOOL_EXECUTION" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SQLTXPLAIN"."TRCA$_FILE"; TO "SQLT_USER_ROLE";
GRANT EXECUTE ON "CTXSYS"."CTX_REPORT" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SYS"."SQLT$_MY_V$SESSION" TO "SQLT_USER_ROLE";
GRANT SELECT ON "SYS"."SQLT$_MY_V$SQL" TO "SQLT_USER_ROLE";

GRANT "SELECT_CATALOG_ROLE"; TO "SQLT_USER_ROLE";

You might also like