tailieunhanh - Using Password File Authentication This section describes how to authenticate an administrative user

Using Password File Authentication This section describes how to authenticate an administrative user using password file authentication. See Also: SQL*Plus User’s Guide and Reference for syntax of the CONNECT command Operating System Group UNIX Windows OSDBA dba ORA_DBA OSOPER oper ORA_OPER See Also: Your operating system specific Oracle documentation for information about creating the OSDBA and OSOPER groups Database Administrator Authentication The Oracle Database Administrator 1-19 Preparing to Use Password File Authentication To enable authentication of an administrative user using password file authentication you must do the following: 1. Create an operating system account for the user. 2. If not already created, Create the password file using the. | Using Password File Authentication This section describes how to authenticate an administrative user using password file authentication. See Also SQL Plus User s Guide and Reference for syntax of the CONNECT command Operating System Group UNIX Windows OSDBA dba ORA_DBA OSOPER oper ORA_OPER See Also Your operating system specific Oracle documentation for information about creating the OSDBA and OSOPER groups Database Administrator Authentication The Oracle Database Administrator 1-19 Preparing to Use Password File Authentication To enable authentication of an administrative user using password file authentication you must do the following 1. Create an operating system account for the user. 2. If not already created Create the password file using the ORAPWD utility ORAPWD FILE filename PASSWORD password ENTRIES max_users 3. Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE. 4. Connect to the database as user SYS or as another user with the administrative privilege . 5. If the user does not already exist in the database create the user. Grant the SYSDBA or SYSOPER system privilege to the user GRANT SYSDBA to scott This statement adds the user to the password file thereby enabling connection AS SYSDBA. Connecting Using Password File Authentication Administrative users can be connected and authenticated to a local or remote database by using the SQL Plus CONNECT command. They must connect using their username and password and with the AS SYSDBA or AS SYSOPER clause. For example user scott has been granted the SYSDBA privilege so he can connect as follows CONNECT scott tiger AS SYSDBA However since scott has not been granted the SYSOPER privilege the following command will fail CONNECT scott tiger AS SYSOPER See Also Creating and Maintaining a Password File on page 1-20 for instructions for creating and maintaining a password file Creating and Maintaining a Password File 1-20 Oracle9 i Database Administrator s Guide Creating and Maintaining a .

TỪ KHÓA LIÊN QUAN
crossorigin="anonymous">
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.