If a shared password file must be used, ensure that the password for SYS is at least 12 characters long and includes a combination of upper- and lowercase alphabetic, numeric, and special characters to fend off a brute-force attack.
When you create the password file, the
users are placed there automatically.
user is there, in this example, because we granted
privileges to a
user in an earlier lesson.
The two columns at farthest right are character string columns that contain either “
” or “
depending on whether a user has the corresponding privilege
. The column names are really
, but the headings are truncated because Server Manager (and SQL*PLUS) truncates the names to match the size of the column, which is five characters.
user, in this example, ha
, but not the
and SYS users have both privileges: