關(guān)于restricting，restricted這個(gè)問題很多朋友還不知道，今天小六來為大家解答以上的問題，現(xiàn)在讓我們一起來看看吧！
1、數(shù)據(jù)庫受限模式，在這個(gè)模式下只有RESTRICTED SESSION 權(quán)限的人才可以登陸，一般用與數(shù)據(jù)庫維護(hù)的時(shí)候使用。
2、RESTRICTED SESSION ClauseThe RESTRICTED SESSION clause lets you restrict logon to Oracle.You can use this clause regardless of whether your instance has the databasedismounted or mounted, open or closed.Restricting Session Logons: Example You may want to restrict logons if you areperforming application maintenance and you want only application developerswith RESTRICTED SESSION system privilege to log on. To restrict logons, issue thefollowing statement:ALTER SYSTEMENABLE RESTRICTED SESSION;You can then terminate any existing sessions using the KILL SESSION clause of theALTER SYSTEM statement.After performing maintenance on your application, issue the following statement toallow any user with CREATE SESSION system privilege to log on:ALTER SYSTEMDISABLE RESTRICTED SESSION;轉(zhuǎn)載，僅供參考。
本文分享完畢，希望對(duì)大家有所幫助。
標(biāo)簽：
免責(zé)聲明：本文由用戶上傳，如有侵權(quán)請(qǐng)聯(lián)系刪除！