[ОТВЕТИТЬ]
Опции темы
31.10.2013 09:05  
OlegON
Код:
GRANT EXECUTE ON "SYS"."UTL_RAW" TO "IBS";
GRANT SELECT ON "SYS"."V_$PROCESS" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$SESSION" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$LICENSE" TO "IBS";
GRANT SELECT ON "SYS"."V_$LOCK" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$SESSTAT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$MYSTAT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$SYSSTAT" TO "IBS";
GRANT SELECT ON "SYS"."V_$STATNAME" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$OSSTAT" TO "IBS";
GRANT SELECT ON "SYS"."V_$PARAMETER" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$DATABASE" TO "IBS";
GRANT SELECT ON "SYS"."V_$INSTANCE" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$SQLAREA" TO "IBS";
GRANT SELECT ON "SYS"."V_$SQLTEXT" TO "IBS";
GRANT SELECT ON "SYS"."V_$DB_PIPES" TO "IBS";
GRANT SELECT ON "SYS"."V_$DB_OBJECT_CACHE" TO "IBS";
GRANT SELECT ON "SYS"."V_$SGASTAT" TO "IBS";
GRANT SELECT ON "SYS"."V_$SESSION_WAIT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$SESSION_EVENT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$SYSTEM_EVENT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$EVENT_NAME" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."V_$SESS_IO" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$PROCESS" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$SESSION" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$LOCK" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$SESSTAT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$SYSSTAT" TO "IBS";
GRANT SELECT ON "SYS"."GV_$STATNAME" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$PARAMETER" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$INSTANCE" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$SQLAREA" TO "IBS";
GRANT SELECT ON "SYS"."GV_$SQLTEXT" TO "IBS";
GRANT SELECT ON "SYS"."GV_$DB_PIPES" TO "IBS";
GRANT SELECT ON "SYS"."GV_$SGASTAT" TO "IBS";
GRANT SELECT ON "SYS"."GV_$SESSION_WAIT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$SESSION_EVENT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$SYSTEM_EVENT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$EVENT_NAME" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$SESS_IO" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."DBA_CONS_COLUMNS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_INDEXES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_IND_COLUMNS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_IND_EXPRESSIONS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_OBJECTS" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."DBA_ROLE_PRIVS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_SEQUENCES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_SYNONYMS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TABLES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_OBJECT_TABLES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_ALL_TABLES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TAB_COLS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TAB_COLUMNS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TAB_PRIVS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_VIEWS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_CONSTRAINTS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_UNUSED_COL_TABS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_LIBRARIES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_USERS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_SYS_PRIVS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TYPES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_COLL_TYPES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TYPE_ATTRS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TYPE_METHODS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_METHOD_RESULTS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_NESTED_TABLE_COLS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_NESTED_TABLES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TAB_PARTITIONS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_IND_PARTITIONS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_PART_COL_STATISTICS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_ERRORS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_SOURCE" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TRIGGERS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TRIGGER_COLS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_DEPENDENCIES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_JOBS" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."DBA_EXTENTS" TO "IBS";
GRANT SELECT ON "SYS"."DBA_DATA_FILES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TABLESPACES" TO "IBS";
GRANT SELECT ON "SYS"."DBA_TABLESPACE_GROUPS" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_LOB" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_SQL" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_OUTPUT" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_SESSION" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_LOCK" TO "IBS";
GRANT EXECUTE ON "SYS"."UTL_FILE" TO "IBS";
GRANT SELECT ON "SYS"."V_$CONTEXT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$CONTEXT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."DBA_CONTEXT" TO "IBS";
GRANT SELECT ON "SYS"."V_$GLOBALCONTEXT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GV_$GLOBALCONTEXT" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."GLOBAL_CONTEXT" TO "IBS" WITH GRANT OPTION;
GRANT EXECUTE ON "SYS"."DBMS_UTILITY" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_APPLICATION_INFO" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_PIPE" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_ALERT" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_JOB" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_STATS" TO "IBS";
GRANT EXECUTE ON "SYS"."UTL_RECOMP" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_RLS" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_SHARED_POOL" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_AQ" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_AQADM" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_SYSTEM" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_AQ_BQVIEW" TO "IBS";
GRANT EXECUTE ON "SYS"."DBMS_SCHEDULER" TO "IBS";
GRANT SELECT ON "SYS"."DBA_SCHEDULER_JOBS" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "SYS"."DBA_LOCK" TO "IBS";
GRANT SELECT ON "SYS"."DBA_LOCK_INTERNAL" TO "IBS";
GRANT SELECT ON "SYS"."DBA_ROLE_PRIVS_SIMPLE" TO "IBS";
GRANT SELECT ON "SYS"."DBA_NESTED_TABLES_SIMPLE" TO "IBS";
GRANT SELECT ON "SYS"."DBA_ERRORS_SIMPLE" TO "IBS";
GRANT SELECT ON "SYS"."USER_NESTED_TABLES_SIMPLE" TO "IBS";
GRANT SELECT ON "SYS"."ALL_SYNONYMS_SIMPLE" TO "IBS";
GRANT SELECT ON "SYS"."USER_ERRORS_SIMPLE" TO "IBS";
GRANT SELECT ON "SYS"."DBA_CONSTRAINTS_1" TO "IBS";
GRANT SELECT ON "SYS"."DBA_CONS_COLUMNS_1" TO "IBS";
GRANT SELECT ON "SYS"."DBA_IND_COLUMNS_1" TO "IBS";
GRANT SELECT ON "SYS"."QT16576_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT17005_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16999_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16618_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16612_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16606_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16969_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16963_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16993_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16987_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16981_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16975_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16957_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16951_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT16582_BUFFER" TO "IBS";
GRANT SELECT ON "SYS"."QT17011_BUFFER" TO "IBS";
GRANT SELECT ON "AUD"."DIARY_ID" TO "IBS";
GRANT SELECT ON "AUD"."OCH_ID" TO "IBS";
GRANT SELECT ON "AUD"."OSH_ID" TO "IBS";
GRANT SELECT ON "AUD"."VALS_ID" TO "IBS";
GRANT SELECT ON "AUD"."EDH_ID" TO "IBS";
GRANT EXECUTE ON "AUD"."LIC_MGR" TO "IBS";
GRANT SELECT ON "AUD"."AUDIT_SETTINGS" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."AUDIT_NOTIFICATIONS" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."AUDIT_RECIPIENTS" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."AUDIT_MESSAGES" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_OSH" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_VALSH" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_DP" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_DIARY2" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_DIARY7" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_DIARY1" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_DIARY3" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_DIARY5" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_DIARY4" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_OCH" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_DIARY6" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."IBS_EDH" TO "IBS" WITH GRANT OPTION;
GRANT EXECUTE ON "AUD"."OSH_INS" TO "IBS";
GRANT EXECUTE ON "AUD"."VALSH_INS" TO "IBS";
GRANT EXECUTE ON "AUD"."DPARAM_INS" TO "IBS";
GRANT EXECUTE ON "AUD"."DIARYS_INS" TO "IBS";
GRANT EXECUTE ON "AUD"."SEND_NOTIFY" TO "IBS";
GRANT EXECUTE ON "AUD"."SEND_NOTIFY_BIG" TO "IBS";
GRANT EXECUTE ON "AUD"."OCH_INS" TO "IBS";
GRANT EXECUTE ON "AUD"."EDH_INS" TO "IBS";
GRANT SELECT ON "AUD"."LICENSE_PARAMS" TO "IBS" WITH GRANT OPTION;
GRANT SELECT ON "AUD"."VW_LICENSE_REPORT" TO "IBS" WITH GRANT OPTION;

GRANT EXECUTE ON "SYS"."UTL_RAW" TO "AUD";
GRANT SELECT ON "SYS"."V_$PROCESS" TO "AUD";
GRANT SELECT ON "SYS"."V_$SESSION" TO "AUD";
GRANT SELECT ON "SYS"."V_$LOCK" TO "AUD";
GRANT SELECT ON "SYS"."V_$MYSTAT" TO "AUD";
GRANT SELECT ON "SYS"."DBA_ROLE_PRIVS" TO "AUD";
GRANT EXECUTE ON "SYS"."DBMS_SQL" TO "AUD";
GRANT EXECUTE ON "SYS"."DBMS_OUTPUT" TO "AUD";
GRANT EXECUTE ON "SYS"."DBMS_SESSION" TO "AUD";
GRANT EXECUTE ON "SYS"."DBMS_LOCK" TO "AUD";
GRANT EXECUTE ON "SYS"."UTL_FILE" TO "AUD";
GRANT EXECUTE ON "SYS"."DBMS_UTILITY" TO "AUD";
GRANT EXECUTE ON "SYS"."UTL_SMTP" TO "AUD";

GRANT SELECT ON "SYS"."USER$" TO "AUDM";
GRANT SELECT ON "SYS"."USER_ASTATUS_MAP" TO "AUDM";
GRANT SELECT ON "SYS"."AUD$" TO "AUDM";
GRANT DELETE ON "SYS"."AUD$" TO "AUDM";
GRANT SELECT ON "SYS"."V_$PROCESS" TO "AUDM";
GRANT SELECT ON "SYS"."V_$SESSION" TO "AUDM";
GRANT SELECT ON "SYS"."V_$LOCK" TO "AUDM";
GRANT SELECT ON "SYS"."V_$MYSTAT" TO "AUDM";
GRANT SELECT ON "SYS"."V_$PARAMETER" TO "AUDM";
GRANT SELECT ON "SYS"."DBA_OBJECTS" TO "AUDM";
GRANT SELECT ON "SYS"."DBA_TAB_COLUMNS" TO "AUDM";
GRANT SELECT ON "SYS"."DBA_USERS" TO "AUDM";
GRANT SELECT ON "SYS"."DBA_PRIV_AUDIT_OPTS" TO "AUDM";
GRANT SELECT ON "SYS"."DBA_AUDIT_TRAIL" TO "AUDM";
GRANT SELECT ON "SYS"."DBA_JOBS" TO "AUDM";
GRANT EXECUTE ON "SYS"."DBMS_LOCK" TO "AUDM";
GRANT EXECUTE ON "SYS"."DBMS_UTILITY" TO "AUDM";
GRANT EXECUTE ON "SYS"."DBMS_PIPE" TO "AUDM";
GRANT EXECUTE ON "SYS"."DBMS_ALERT" TO "AUDM";
 
 
Опции темы



Часовой пояс GMT +3, время: 10:47.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.