Oracle Password File
来源:互联网 发布:摔软件表情 编辑:程序博客网 时间:2024/05/21 19:24
Creating a Password File and Adding New Users to It
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 "Creating a Password File with ORAPWD" on page 1-23.
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, and enter the SYS password when prompted:CONNECT SYS AS SYSDBA
4. Start up the instance and create the databa se 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. See "Granting and Revoking SYSDBA and SYSOPER Privileges" , later in this section.
1. Identify the users who have SYSDBA or SYSOPER privileges by querying the V$PWFILE_USERS view.
2. Delete the existing password file.
3. Follow the instructions for creating a new password file using the ORAPWD utility in "Creating a Password File with ORAPWD" on page 1-23. Ensure that the ENTRIES parameter is set to a number larger than you think you will ever need.
4. Follow the instructions in "Adding Users to a Password File" on page 1-26.
ps: REMOTE_LOGIN_PASSWORDFILE is in $ORACLE_HOME/dbs/init.ora
- Oracle中password file
- Oracle's password file
- Oracle Password File
- oracle password file 命名规则
- oracle密码文件认证(password file authentication)
- 读书笔记20120213----Oracle password file, block change-tracking file
- Password file
- Oracle中password file的作用及说明
- Oracle中password file的作用及说明
- Oracle中password file的作用及说明
- Oracle中password file的作用及说明
- Oracle学习:password file的作用及说明(转帖)
- Oracle中password file的作用及说明
- Oracle中password file的作用及说明
- Oracle中password file的作用及说明
- Oracle中password file orapwd的作用及说明
- Oracle中password file orapwd的作用及说明
- 20151117 password file
- Android Proguard混淆打包经验总结
- 说说JSON和JSONP,也许你会豁然开朗,含jQuery用例
- Oracle ORAPWD
- 第一个,测试
- Python MySQLdb
- Oracle Password File
- 【图像处理】C#实现哈哈镜效果
- Create database in command-line
- Oracle view
- Use command to create database
- 一、类的声明和实现
- Oracle 迭代查询
- Shell SED 使用
- Android屏幕自适应