Creating a Password File and Adding New Users to It (47)

tsinglee發表於2007-12-21

Use the following procedure to create a password and add new users to it:
1. Follow the instructions for creating a password file as explained in "Using
ORAPWD"
2. Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE.
(This is the default.)
3. Connect with SYSDBA privileges as shown in the following example:
CONNECT SYS/password AS SYSDBA
4. Start up the instance and create the database if necessary, or mount and open an
existing database.
5. Create users as necessary. Grant SYSDBA or SYSOPER privileges to yourself and
other users as appropriate.

建立密碼檔案並新增使用者
1. 使用orapwd
2. 將REMOTE_LOGIN_PASSWORDFILE引數化引數設定為EXCLUSIVE
3. 以sysdba連線
4. 啟動例項,建立資料庫. 或者裝載開啟已有的資料庫
5. 建立使用者 , 賦予sysdba許可權

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-995390/,如需轉載,請註明出處,否則將追究法律責任。

相關文章