This preview shows page 1. Sign up to view the full content.
Unformatted text preview: SYSDBA and SYSOPER system privileges to individual users and have them connect
as themselves. Setting this parameter to NONE causes Oracle to behave as if the password file
does not exist. That is, no privileged connections are allowed over non-secure connections.
NONE is the default value for this parameter. A SHARED password file can be used by multiple
databases. However, the only user recognized by a SHARED password file is SYS. You cannot
add users to a SHARED password file. All users needing SYSDBA or SYSOPER system
privileges must connect using the same name, SYS, and password.
A: The password file needs to be stored on the host machine in any case.
B: Password file access is restricted to remote, not local, users.
E: Remote connections using SYSDBA privilege will be allowed, not prohibited.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 275-281
Chapter 6: Basics of the Oracle Database Architecture
You are logged on to a client. You do not have a secure connection from your client...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09