Oracle SYS用戶無法設(shè)置session級別的read only

發(fā)布時間：2020-08-19 02:36:20 來源：ITPUB博客閱讀：151 作者：kisslfcr 欄目：關(guān)系型數(shù)據(jù)庫

官方文檔參考：
SYSDBA is used internally in the Oracle database and has specialized functions. Its behavior is not the same as for generalized users. For example, the SYS user cannot do a transaction level consistent read (read-only transaction). Queries by SYS will return changes made during the transaction even if SYS has set the transaction to be READ ONLY. Therefore export parameters like CONSISTENT, OBJECT_CONSISTENT, FLASHBACK_SCN, and FLASHBACK_TIME cannot be used.

進(jìn)行Oracle事務(wù)相關(guān)的實(shí)驗(yàn)時，要盡量使用普通用戶，因?yàn)楹芏嗍聞?wù)級別的設(shè)置，對于sqlplus / as sysdba連入方式無法獲得正確的結(jié)果。
如果想給用戶獲取數(shù)據(jù)字典以方便實(shí)驗(yàn)的目的可給用戶賦予如下權(quán)限：
GRANT CONNECT,RESOURCE,SELECT ANY DICTIONARY,SELECT ANY TABLE TO TUSER;

參考：How To Connect As SYSDBA When Using Export Or Import (文檔 ID 277237.1)

向AI問一下細(xì)節(jié)

Oracle SYS用戶無法設(shè)置session級別的read only

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽