只读用户的建立.--- 参考样本-CSDN博客

只读用户的建立.

++++++++++++++++++++++++++++++++

DROP USER OVSEE CASCADE;

CREATE USER OVSEE
IDENTIFIED BY VALUES 'CD74BCD8C41619A0'
DEFAULT TABLESPACE REPDATA
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;

-- 2 Roles for OVSEE
GRANT RESOURCE TO OVSEE;
GRANT SELECT_CATALOG_ROLE TO OVSEE;
ALTER USER OVSEE DEFAULT ROLE ALL;

-- 6 System Privileges for OVSEE
GRANT ALTER SESSION TO OVSEE;
GRANT CREATE DATABASE LINK TO OVSEE;
GRANT CREATE SESSION TO OVSEE;
GRANT CREATE VIEW TO OVSEE;
GRANT RESTRICTED SESSION TO OVSEE;
GRANT UNLIMITED TABLESPACE TO OVSEE;
-- 1 Tablespace Quota for OVSEE
ALTER USER OVSEE QUOTA 200M ON REPDATA;

-- 244 Object Privileges for OVSEE
    GRANT SELECT ON DBMGR.CBO_BACKUP_INFO TO OVSEE;
    GRANT SELECT ON DBMGR.CBO_STATS_BAK TO OVSEE;
    GRANT SELECT ON DBMGR.FACTUSER_LIST TO OVSEE;
    GRANT SELECT ON DBMGR.REDO_ALERT_KILL_REC_TBL TO OVSEE;
    GRANT SELECT ON DBMGR.REDO_ALERT_KILL_REC_TBL_OLD TO OVSEE;
    GRANT SELECT ON DBMGR.STATS_GATHER_DEGREE TO OVSEE;
    GRANT SELECT ON DBMGR.STATS_GATHER_LOG TO OVSEE;
    GRANT SELECT ON DBMGR.STATS_GATHER_LOG1 TO OVSEE;
    GRANT SELECT ON DBMGR.STATS_GATHER_LOG_DETAIL TO OVSEE;
    GRANT SELECT ON DBMGR.STATS_GATHER_LOG_DETAIL1 TO OVSEE;
    GRANT SELECT ON DBMGR.STATS_GLOBAL_CONFIG TO OVSEE;
    GRANT SELECT ON DBMGR.STATS_OBJECT_CONFIG TO OVSEE;
    GRANT SELECT ON DBMGR.STATS_ROLLBACK_DB_LIST TO OVSEE;
    GRANT SELECT ON DBMGR.STATS_SCHEMA_CONFIG TO OVSEE;
    GRANT SELECT ON DBMGR.STAT_ITL_WAITS TO OVSEE;
    GRANT SELECT ON DBMGR.SYS_USERS TO OVSEE;
    GRANT SELECT ON DBMON.DB_UPTIME TO OVSEE;
    GRANT SELECT ON LIFEMENU.MON_TRIGGER_EXIST TO OVSEE;
    GRANT SELECT ON LIFEMENU.MON_TRIGGER_STATUS TO OVSEE;
    GRANT SELECT ON SYS.DBA_2PC_NEIGHBORS TO OVSEE;
    GRANT SELECT ON SYS.DBA_2PC_PENDING TO OVSEE;
    GRANT SELECT ON SYS.DBA_ALL_TABLES TO OVSEE;
    GRANT SELECT ON SYS.DBA_ANALYZE_OBJECTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_AUDIT_EXISTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_AUDIT_OBJECT TO OVSEE;
    GRANT SELECT ON SYS.DBA_AUDIT_SESSION TO OVSEE;
    GRANT SELECT ON SYS.DBA_AUDIT_STATEMENT TO OVSEE;
    GRANT SELECT ON SYS.DBA_AUDIT_TRAIL TO OVSEE;
    GRANT SELECT ON SYS.DBA_CATALOG TO OVSEE;
    GRANT SELECT ON SYS.DBA_CLUSTERS TO OVSEE;
    GRANT SELECT ON SYS.DBA_CLUSTER_HASH_EXPRESSIONS TO OVSEE;
    GRANT SELECT ON SYS.DBA_CLU_COLUMNS TO OVSEE;
    GRANT SELECT ON SYS.DBA_COLL_TYPES TO OVSEE;
    GRANT SELECT ON SYS.DBA_COL_COMMENTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_COL_PRIVS TO OVSEE;
    GRANT SELECT ON SYS.DBA_CONSTRAINTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_CONS_COLUMNS TO OVSEE;
    GRANT SELECT ON SYS.DBA_DATA_FILES TO OVSEE;
    GRANT SELECT ON SYS.DBA_DB_LINKS TO OVSEE;
    GRANT SELECT ON SYS.DBA_DEPENDENCIES TO OVSEE;
    GRANT SELECT ON SYS.DBA_DIRECTORIES TO OVSEE;
    GRANT SELECT ON SYS.DBA_ERRORS TO OVSEE;
    GRANT SELECT ON SYS.DBA_EXP_FILES TO OVSEE;
    GRANT SELECT ON SYS.DBA_EXP_OBJECTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_EXP_VERSION TO OVSEE;
    GRANT SELECT ON SYS.DBA_EXTENTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_FREE_SPACE TO OVSEE;
    GRANT SELECT ON SYS.DBA_FREE_SPACE_COALESCED TO OVSEE;
    GRANT SELECT ON SYS.DBA_FREE_SPACE_COALESCED_TMP1 TO OVSEE;
    GRANT SELECT ON SYS.DBA_FREE_SPACE_COALESCED_TMP2 TO OVSEE;
    GRANT SELECT ON SYS.DBA_INDEXES TO OVSEE;
    GRANT SELECT ON SYS.DBA_IND_COLUMNS TO OVSEE;
    GRANT SELECT ON SYS.DBA_IND_PARTITIONS TO OVSEE;
    GRANT SELECT ON SYS.DBA_JOBS TO OVSEE;
    GRANT SELECT ON SYS.DBA_JOBS_RUNNING TO OVSEE;
    GRANT SELECT ON SYS.DBA_LIBRARIES TO OVSEE;
    GRANT SELECT ON SYS.DBA_LOBS TO OVSEE;
    GRANT SELECT ON SYS.DBA_METHOD_PARAMS TO OVSEE;
    GRANT SELECT ON SYS.DBA_METHOD_RESULTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_NESTED_TABLES TO OVSEE;
    GRANT SELECT ON SYS.DBA_OBJECTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_OBJECT_SIZE TO OVSEE;
    GRANT SELECT ON SYS.DBA_OBJECT_TABLES TO OVSEE;
    GRANT SELECT ON SYS.DBA_OBJ_AUDIT_OPTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_PART_COL_STATISTICS TO OVSEE;
    GRANT SELECT ON SYS.DBA_PART_HISTOGRAMS TO OVSEE;
    GRANT SELECT ON SYS.DBA_PART_INDEXES TO OVSEE;
    GRANT SELECT ON SYS.DBA_PART_KEY_COLUMNS TO OVSEE;
    GRANT SELECT ON SYS.DBA_PART_TABLES TO OVSEE;
    GRANT SELECT ON SYS.DBA_PENDING_TRANSACTIONS TO OVSEE;
    GRANT SELECT ON SYS.DBA_PRIV_AUDIT_OPTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_PROFILES TO OVSEE;
    GRANT SELECT ON SYS.DBA_QUEUES TO OVSEE;
    GRANT SELECT ON SYS.DBA_QUEUE_SCHEDULES TO OVSEE;
    GRANT SELECT ON SYS.DBA_QUEUE_TABLES TO OVSEE;
    GRANT SELECT ON SYS.DBA_RCHILD TO OVSEE;
    GRANT SELECT ON SYS.DBA_REFRESH TO OVSEE;
    GRANT SELECT ON SYS.DBA_REFRESH_CHILDREN TO OVSEE;
    GRANT SELECT ON SYS.DBA_REFS TO OVSEE;
    GRANT SELECT ON SYS.DBA_REGISTERED_SNAPSHOTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_RGROUP TO OVSEE;
    GRANT SELECT ON SYS.DBA_ROLES TO OVSEE;
    GRANT SELECT ON SYS.DBA_ROLE_PRIVS TO OVSEE;
    GRANT SELECT ON SYS.DBA_ROLLBACK_SEGS TO OVSEE;
    GRANT SELECT ON SYS.DBA_SEGMENTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_SEQUENCES TO OVSEE;
    GRANT SELECT ON SYS.DBA_SNAPSHOTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_SNAPSHOT_LOGS TO OVSEE;
    GRANT SELECT ON SYS.DBA_SOURCE TO OVSEE;
    GRANT SELECT ON SYS.DBA_STMT_AUDIT_OPTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_SYNONYMS TO OVSEE;
    GRANT SELECT ON SYS.DBA_SYS_PRIVS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TABLES TO OVSEE;
    GRANT SELECT ON SYS.DBA_TABLESPACES TO OVSEE;
    GRANT SELECT ON SYS.DBA_TAB_COLUMNS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TAB_COL_STATISTICS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TAB_COMMENTS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TAB_HISTOGRAMS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TAB_PARTITIONS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TAB_PRIVS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TRIGGERS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TRIGGER_COLS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TS_QUOTAS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TYPES TO OVSEE;
    GRANT SELECT ON SYS.DBA_TYPE_ATTRS TO OVSEE;
    GRANT SELECT ON SYS.DBA_TYPE_METHODS TO OVSEE;
    GRANT SELECT ON SYS.DBA_UPDATABLE_COLUMNS TO OVSEE;
    GRANT SELECT ON SYS.DBA_USERS TO OVSEE;
    GRANT SELECT ON SYS.DBA_VIEWS TO OVSEE;
    GRANT EXECUTE ON SYS.DBMS_JOB TO OVSEE;
    GRANT EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY TO OVSEE;
    GRANT SELECT ON SYS.FILEXT$ TO OVSEE;
    GRANT SELECT ON SYS.V_$ACCESS TO OVSEE;
    GRANT SELECT ON SYS.V_$ACTIVE_INSTANCES TO OVSEE;
    GRANT SELECT ON SYS.V_$AQ1 TO OVSEE;
    GRANT SELECT ON SYS.V_$ARCHIVE TO OVSEE;
    GRANT SELECT ON SYS.V_$ARCHIVED_LOG TO OVSEE;
    GRANT SELECT ON SYS.V_$ARCHIVE_DEST TO OVSEE;
    GRANT SELECT ON SYS.V_$BACKUP TO OVSEE;
    GRANT SELECT ON SYS.V_$BACKUP_CORRUPTION TO OVSEE;
    GRANT SELECT ON SYS.V_$BACKUP_DATAFILE TO OVSEE;
    GRANT SELECT ON SYS.V_$BACKUP_DEVICE TO OVSEE;
    GRANT SELECT ON SYS.V_$BACKUP_PIECE TO OVSEE;
    GRANT SELECT ON SYS.V_$BACKUP_REDOLOG TO OVSEE;
    GRANT SELECT ON SYS.V_$BACKUP_SET TO OVSEE;
    GRANT SELECT ON SYS.V_$BGPROCESS TO OVSEE;
    GRANT SELECT ON SYS.V_$BH TO OVSEE;
    GRANT SELECT ON SYS.V_$BUFFER_POOL TO OVSEE;
    GRANT SELECT ON SYS.V_$CIRCUIT TO OVSEE;
    GRANT SELECT ON SYS.V_$CLASS_PING TO OVSEE;
    GRANT SELECT ON SYS.V_$CONTROLFILE TO OVSEE;
    GRANT SELECT ON SYS.V_$CONTROLFILE_RECORD_SECTION TO OVSEE;
    GRANT SELECT ON SYS.V_$COPY_CORRUPTION TO OVSEE;
    GRANT SELECT ON SYS.V_$DATABASE TO OVSEE;
    GRANT SELECT ON SYS.V_$DATAFILE TO OVSEE;
    GRANT SELECT ON SYS.V_$DATAFILE_COPY TO OVSEE;
    GRANT SELECT ON SYS.V_$DATAFILE_HEADER TO OVSEE;
    GRANT SELECT ON SYS.V_$DBFILE TO OVSEE;
    GRANT SELECT ON SYS.V_$DBLINK TO OVSEE;
    GRANT SELECT ON SYS.V_$DB_OBJECT_CACHE TO OVSEE;
    GRANT SELECT ON SYS.V_$DB_PIPES TO OVSEE;
    GRANT SELECT ON SYS.V_$DELETED_OBJECT TO OVSEE;
    GRANT SELECT ON SYS.V_$DISPATCHER TO OVSEE;
    GRANT SELECT ON SYS.V_$DISPATCHER_RATE TO OVSEE;
    GRANT SELECT ON SYS.V_$DLM_CONVERT_LOCAL TO OVSEE;
    GRANT SELECT ON SYS.V_$DLM_CONVERT_REMOTE TO OVSEE;
    GRANT SELECT ON SYS.V_$DLM_LATCH TO OVSEE;
    GRANT SELECT ON SYS.V_$DLM_LOCKS TO OVSEE;
    GRANT SELECT ON SYS.V_$DLM_MISC TO OVSEE;
    GRANT SELECT ON SYS.V_$ENABLEDPRIVS TO OVSEE;
    GRANT SELECT ON SYS.V_$ENQUEUE_LOCK TO OVSEE;
    GRANT SELECT ON SYS.V_$EVENT_NAME TO OVSEE;
    GRANT SELECT ON SYS.V_$EXECUTION TO OVSEE;
    GRANT SELECT ON SYS.V_$FILESTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$FILE_PING TO OVSEE;
    GRANT SELECT ON SYS.V_$FIXED_TABLE TO OVSEE;
    GRANT SELECT ON SYS.V_$FIXED_VIEW_DEFINITION TO OVSEE;
    GRANT SELECT ON SYS.V_$GLOBAL_TRANSACTION TO OVSEE;
    GRANT SELECT ON SYS.V_$INDEXED_FIXED_COLUMN TO OVSEE;
    GRANT SELECT ON SYS.V_$INSTANCE TO OVSEE;
    GRANT SELECT ON SYS.V_$LATCH TO OVSEE;
    GRANT SELECT ON SYS.V_$LATCHHOLDER TO OVSEE;
    GRANT SELECT ON SYS.V_$LATCHNAME TO OVSEE;
    GRANT SELECT ON SYS.V_$LATCH_CHILDREN TO OVSEE;
    GRANT SELECT ON SYS.V_$LATCH_MISSES TO OVSEE;
    GRANT SELECT ON SYS.V_$LATCH_PARENT TO OVSEE;
    GRANT SELECT ON SYS.V_$LIBRARYCACHE TO OVSEE;
    GRANT SELECT ON SYS.V_$LICENSE TO OVSEE;
    GRANT SELECT ON SYS.V_$LOADPSTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$LOCK TO OVSEE;
    GRANT SELECT ON SYS.V_$LOCKED_OBJECT TO OVSEE;
    GRANT SELECT ON SYS.V_$LOCKS_WITH_COLLISIONS TO OVSEE;
    GRANT SELECT ON SYS.V_$LOCK_ACTIVITY TO OVSEE;
    GRANT SELECT ON SYS.V_$LOCK_ELEMENT TO OVSEE;
    GRANT SELECT ON SYS.V_$LOG TO OVSEE;
    GRANT SELECT ON SYS.V_$LOGFILE TO OVSEE;
    GRANT SELECT ON SYS.V_$LOGHIST TO OVSEE;
    GRANT SELECT ON SYS.V_$LOG_HISTORY TO OVSEE;
    GRANT SELECT ON SYS.V_$MYSTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$NLS_PARAMETERS TO OVSEE;
    GRANT SELECT ON SYS.V_$NLS_VALID_VALUES TO OVSEE;
    GRANT SELECT ON SYS.V_$OBJECT_DEPENDENCY TO OVSEE;
    GRANT SELECT ON SYS.V_$OFFLINE_RANGE TO OVSEE;
    GRANT SELECT ON SYS.V_$OPEN_CURSOR TO OVSEE;
    GRANT SELECT ON SYS.V_$OPTION TO OVSEE;
    GRANT SELECT ON SYS.V_$PARAMETER TO OVSEE;
    GRANT SELECT ON SYS.V_$PQ_SESSTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$PQ_SLAVE TO OVSEE;
    GRANT SELECT ON SYS.V_$PQ_SYSSTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$PQ_TQSTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$PROCESS TO OVSEE;
    GRANT SELECT ON SYS.V_$PWFILE_USERS TO OVSEE;
    GRANT SELECT ON SYS.V_$QUEUE TO OVSEE;
    GRANT SELECT ON SYS.V_$RECOVERY_FILE_STATUS TO OVSEE;
    GRANT SELECT ON SYS.V_$RECOVERY_LOG TO OVSEE;
    GRANT SELECT ON SYS.V_$RECOVERY_PROGRESS TO OVSEE;
    GRANT SELECT ON SYS.V_$RECOVERY_STATUS TO OVSEE;
    GRANT SELECT ON SYS.V_$RECOVER_FILE TO OVSEE;
    GRANT SELECT ON SYS.V_$REQDIST TO OVSEE;
    GRANT SELECT ON SYS.V_$RESOURCE TO OVSEE;
    GRANT SELECT ON SYS.V_$RESOURCE_LIMIT TO OVSEE;
    GRANT SELECT ON SYS.V_$ROLLNAME TO OVSEE;
    GRANT SELECT ON SYS.V_$ROLLSTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$ROWCACHE TO OVSEE;
    GRANT SELECT ON SYS.V_$ROWCACHE_PARENT TO OVSEE;
    GRANT SELECT ON SYS.V_$ROWCACHE_SUBORDINATE TO OVSEE;
    GRANT SELECT ON SYS.V_$SESSION TO OVSEE;
    GRANT SELECT ON SYS.V_$SESSION_CONNECT_INFO TO OVSEE;
    GRANT SELECT ON SYS.V_$SESSION_CURSOR_CACHE TO OVSEE;
    GRANT SELECT ON SYS.V_$SESSION_EVENT TO OVSEE;
    GRANT SELECT ON SYS.V_$SESSION_LONGOPS TO OVSEE;
    GRANT SELECT ON SYS.V_$SESSION_OBJECT_CACHE TO OVSEE;
    GRANT SELECT ON SYS.V_$SESSION_WAIT TO OVSEE;
    GRANT SELECT ON SYS.V_$SESSTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$SESS_IO TO OVSEE;
    GRANT SELECT ON SYS.V_$SGA TO OVSEE;
    GRANT SELECT ON SYS.V_$SGASTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$SHARED_POOL_RESERVED TO OVSEE;
    GRANT SELECT ON SYS.V_$SHARED_SERVER TO OVSEE;
    GRANT SELECT ON SYS.V_$SORT_SEGMENT TO OVSEE;
    GRANT SELECT ON SYS.V_$SORT_USAGE TO OVSEE;
    GRANT SELECT ON SYS.V_$SQL TO OVSEE;
    GRANT SELECT ON SYS.V_$SQLAREA TO OVSEE;
    GRANT SELECT ON SYS.V_$SQLTEXT TO OVSEE;
    GRANT SELECT ON SYS.V_$SQLTEXT_WITH_NEWLINES TO OVSEE;
    GRANT SELECT ON SYS.V_$SQL_BIND_DATA TO OVSEE;
    GRANT SELECT ON SYS.V_$SQL_BIND_METADATA TO OVSEE;
    GRANT SELECT ON SYS.V_$SQL_CURSOR TO OVSEE;
    GRANT SELECT ON SYS.V_$SQL_SHARED_MEMORY TO OVSEE;
    GRANT SELECT ON SYS.V_$STATNAME TO OVSEE;
    GRANT SELECT ON SYS.V_$SUBCACHE TO OVSEE;
    GRANT SELECT ON SYS.V_$SYSSTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$SYSTEM_CURSOR_CACHE TO OVSEE;
    GRANT SELECT ON SYS.V_$SYSTEM_EVENT TO OVSEE;
    GRANT SELECT ON SYS.V_$SYSTEM_PARAMETER TO OVSEE;
    GRANT SELECT ON SYS.V_$TABLESPACE TO OVSEE;
    GRANT SELECT ON SYS.V_$THREAD TO OVSEE;
    GRANT SELECT ON SYS.V_$TIMER TO OVSEE;
    GRANT SELECT ON SYS.V_$TRANSACTION TO OVSEE;
    GRANT SELECT ON SYS.V_$TRANSACTION_ENQUEUE TO OVSEE;
    GRANT SELECT ON SYS.V_$TYPE_SIZE TO OVSEE;
    GRANT SELECT ON SYS.V_$VERSION TO OVSEE;
    GRANT SELECT ON SYS.V_$WAITSTAT TO OVSEE;
    GRANT SELECT ON SYS.V_$_LOCK TO OVSEE;

++++++++++++++++++++++++++++++++++++++++++++++

ORA600.doc.jpg