Administrative Privileges (31)
Administrative privileges that are required for an administrator to perform basic
database operations are granted through two special system privileges, SYSDBA and
SYSOPER. You must have one of these privileges granted to you, depending upon the
level of authorization you require.
Note: The SYSDBA and SYSOPER system privileges allow access
to a database instance even when the database is not open. Control
of these privileges is totally outside of the database itself.
The SYSDBA and SYSOPER privileges can also be thought of as
types of connections that enable you to perform certain database
operations for which privileges cannot be granted in any other
fashion. For example, you if you have the SYSDBA privilege, you
can connect to the database by specifying CONNECT AS SYSDBA.
管理員許可權
1. 被賦予兩個特殊的系統許可權 , sysdba 與 sysoper
這兩個許可權在資料庫未被開啟的情況下 , 也能夠登入例項
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-994742/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Connecting with Administrative Privileges: Example (33)
- ora-01031:insufficient privileges解決方法
- create view receive "ORA-01031: insufficient privileges"View
- Linux oracle ORA-01031: insufficient privilegesLinuxOracle
- ORA-01031: insufficient privileges的解決方法
- Difference of Revoke System Privileges and Object PrivilegesObject
- ORA-0131:Insufficient privileges.(DEBUG CONNECT SESSION)Session
- ORA-01031: insufficient privileges錯誤解決方法
- oracle rac dg庫報錯ORA-01031: insufficient privilegesOracle
- linux as 2.1 ORA-01031: insufficient privileges 解決方法Linux
- 在AIX 平臺下遇到ORA-01031: insufficient privilegesAI
- RMAN system 遠端連線 ORA-01031: insufficient privileges
- Oracle遠端登入報錯:ora-01031:insufficient privilegesOracle
- SYS遠端連線出錯ORA-01031:Insufficient privileges
- ORA-01031: insufficient privileges重新配置sys登入密碼密碼
- sys使用者遠端登入報ORA-01031 insufficient privileges
- SYS使用者登入Oracle報錯ORA-01031: insufficient privilegesOracle
- sqlplus / as sysdba報錯ORA-01031: insufficient privileges的原因分析SQL
- conn / as sysdba 出現ORA-01031: insufficient privileges 解決辦法
- db2_privilegesDB2
- Administrative User Accounts Provided by Oracle DatabaseIDEOracleDatabase
- ORA-01031: 資料庫恢復時的insufficient privileges錯誤QS資料庫
- 儲存過程編譯報錯:PL/SQL:ORA-01031:insufficient privileges儲存過程編譯SQL
- sys使用者執行 grant授權提示ORA-01031: insufficient privileges
- oracle 10g linux 遠端登入 ORA-01031: insufficient privilegesOracle 10gLinux
- [20240826]奇怪ORA-01031 insufficient privileges報錯.txt
- 11gR2 Restart Database SRVCTL啟動DB報ORA-01031: insufficient privilegesRESTDatabase
- sqlplus "/ as sysdba" 連不上,報ora-01031:insufficient privileges解決方法SQL
- Oracle/PLSQL: Grant/Revoke PrivilegesOracleSQL
- 1.5.2.1. 關於Administrative 使用者
- Privileges on the Defining Function (204)Function
- Oracle的SYS使用者登入報許可權不足(ORA-01031: insufficient privileges)Oracle
- SQL> conn sys/sys@vm_sigle as sysdba; 報ORA-01031: insufficient privileges錯誤SQL
- SQL-based Administrative Task Scheduler in DB2 9.5SQLDB2
- Oracle 軟體克隆後sysdba登入提示沒有許可權ora-01031: insufficient privilegesOracle
- revoke EXECUTE privileges on powerful packages from PUBLICPackage
- SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]Oracle
- Connection with Administrator Privileges (286)