The following steps can be performed to grant other users these privileges:. The filename is the name of the file that will hold the orapwd password information. The file location will default to the current directory unless the full path is specified. The contents are encrypted and are unreadable.
The password required is the one for the SYS user of the database. This parameter should be set to a higher value than the number of anticipated users to prevent having to delete and recreate the password file.
Edit the init. The parameter setting can be confirmed by:. The SYS password should never be shared and should be highly classified. The contents are encrypted and are unreadable. This argument is mandatory.
The filenames allowed for the password file are OS-specific. Some operating systems require the password file to adhere to a specific format and be located in a specific directory.
Other operating systems allow the use of environment variables to specify the name and location of the password file. This is the sys password. An error will be returned if a password file of the same name already exists and this argument is omitted or set to N. Some operating systems require the password file to adhere to a specific format and be located in a specific directory. Other operating systems allow the use of environment variables to specify the name and location of the password file.
For other platforms, consult your platform-specific documentation. In an Oracle Real Application Clusters environment on a platform that requires an environment variable to be set to the path of the password file, the environment variable for each instance must point to the same password file. This argument specifies the number of entries that you require the password file to accept. The actual number of allowable entries can be higher than the number of users, because the ORAPWD utility continues to assign password entries until an operating system block is filled.
For example, if your operating system block size is bytes, it holds four password entries. The number of password entries allocated is always a multiple of four. Entries can be reused as users are added to and removed from the password file. This argument, if set to Y , enables you to overwrite an existing password file. An error is returned if a password file of the same name already exists and this argument is omitted or set to N. If this argument is set to y , passwords are case-insensitive.
That is, case is ignored when comparing the password that the user supplies during login with the password in the password file.
You can also use this parameter to disable password file authentication. That is, no privileged connections are allowed over nonsecure connections. A user's name remains in the password file only as long as that user has at least one of these two privileges.
If you revoke both of these privileges, Oracle Database removes the user from the password file.
0コメント