OracleSYS用戶無(wú)法設(shè)置session級(jí)別的readonly
官方文檔參考：
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)時(shí)，要盡量使用普通用戶，因?yàn)楹芏嗍聞?wù)級(jí)別的設(shè)置，對(duì)于sqlplus / as sysdba連入方式無(wú)法獲得正確的結(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)
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)時(shí)，要盡量使用普通用戶，因?yàn)楹芏嗍聞?wù)級(jí)別的設(shè)置，對(duì)于sqlplus / as sysdba連入方式無(wú)法獲得正確的結(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)
當(dāng)前名稱：OracleSYS用戶無(wú)法設(shè)置session級(jí)別的readonly
本文來(lái)源：http://aaarwkj.com/article24/iihije.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站營(yíng)銷、品牌網(wǎng)站設(shè)計(jì)、電子商務(wù)、網(wǎng)站導(dǎo)航、網(wǎng)頁(yè)設(shè)計(jì)公司、微信公眾號(hào)
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)
- SEO新手如何做好網(wǎng)站排名 2020-10-28
- 做好文章的原創(chuàng)性和內(nèi)部的改造讓你的網(wǎng)站排名更靠前 2022-08-12
- SEO網(wǎng)站排名優(yōu)化的原理是什么 2015-04-26
- 淺談穩(wěn)定網(wǎng)站排名的四大技巧必不可少 2021-07-11
- 原創(chuàng)文章對(duì)企業(yè)網(wǎng)站排名的重要程度 2021-11-07
- 網(wǎng)站建設(shè)如何提升網(wǎng)站排名 2021-11-11
- 影響網(wǎng)站排名的一些問(wèn)題 2016-06-11
- 網(wǎng)站建設(shè)中，如何提升網(wǎng)站排名？ 2016-11-07
- 域名和網(wǎng)站排名有沒(méi)有關(guān)系_深圳網(wǎng)站制作公司 2021-11-06
- 網(wǎng)站排名不到首頁(yè)網(wǎng)站等于零 2021-11-05
- 如何應(yīng)對(duì)網(wǎng)站排名下降的問(wèn)題? 2015-08-09
- 影響網(wǎng)站排名有哪些因素？ 2013-10-04