Using an exclusive password file allows you to grant

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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. Incorrect Answers: 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 QUESTION 117: 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.

Ask a homework question - tutors are online