2023年09月09日（2023年09月09日restricted）
(资料图)
1、数据库受限模式，在这个模式下只有RESTRICTED SESSION 权限的人才可以登陆，一般用与数据库维护的时候使用。
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;转载，仅供参考。
本文就为大家分享到这里，希望会喜欢。
X 关闭
精心推荐
Copyright © 2015-2022 太平洋安防网版权所有 备案号：豫ICP备2022016495号-17 联系邮箱：93 96 74 66 9@qq.com