Creating a Password File and Adding New Users to It (47)
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許可權
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-995390/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Generating a new SSH key and adding it to the SSH-agent
- Author: ** not defined in users.txt file
- Password is required when adding a database to AG group if the database has a master keyUIDatabaseAST
- oracle12.2 adg ORA-46952: standby database format mismatch for password fileOracleDatabaseORM
- 修改sys密碼報錯:ORA-01994: Password file missing or disabled密碼
- 新手必看!使用New File Menu常見問題集錦
- “no source“: Error: #5: cannot open source input file “C:\Users\xxx\AppData\Local\Temp\p4228: PermiErrorAPP
- Oracle default usersOracle
- Adding Drivers into VMWare ESXi Installation Image
- Leaflet入門:新增點線面並匯入GeoJSON資料|Tutorial of Leaflet: Adding Points, Lines, Polygons and Import GeoJSON FileJSONGoImport
- Creating your first iOS FrameworkiOSFramework
- Error creating bean with name 'tomcatEmbeddedServletContainerFactory'ErrorBeanTomcatServletAI
- Error creating bean with name ‘dataSource‘ErrorBean
- 2.2.2.2 Local Users in a CDB
- 2.2.2.1 Common Users in a CDB
- 262-Trips and Users
- Easy New File|讓Mac像Windows一樣可以右鍵新建檔案MacWindows
- Error creating bean with name 解決ErrorBean
- [20191112]SQL Tuning by adding column alias (2).txtSQL
- Django中的函式make_password、set_password和check_passwordDjango函式
- no-wwwtl622com17008768000-password never prompt for password
- 2.2.2 Overview of Common and Local Users in a CDBView
- Avoided redundant navigation to current location: "/users"IDENavigation
- iOS Password AutoFilliOS
- Password Storage - UserDetailsAI
- (桶暴力列舉gcd) CF1627D Not AddingGC
- new self()與new static()
- windchill 擴充USERS表空間
- A way to represent that more realistically might be forcing users
- URL password 屬性
- scp without interative password
- vue47Vue
- error creating overlay mount to invalid argument unbuntu系統Error
- [Paper Reading] ControlNet: Adding Conditional Control to Text-to-Image Diffusion Models
- New
- Spectrum Entropy Prediction Assisted Channel Selection for Secondary Users
- win10系統c盤users在哪_win10系統c盤users怎麼開啟Win10
- php password_hash password_verify 加密驗證不需要saltPHP加密
- JavaScript中的new map()和new set()使用詳細(new map()和new set()的區別)JavaScript