Oracle9i DBA -- Database: Fundamentals I (16)

Managing Users

##CONTINUE##

• A user can be authenticated by the data dictionary, operating system and network.
• ORACNV is a script which can be executed to create a centralized repository of user accounts leading to ease of administration.
• The unlimited tablespace privilege takes priority over quota settings.
• To encrypt a user’s password the ORA_ENCRYPT_LOGIN parameter must be set to true.
• OS_AUTHENT_PREFIX = “” is used to set user name format to a NULL prefix. OS_AUTHENT_PREFIX = OPS$ will allow the user to be authenticated by the OS or the Oracle server. Create User OPS$xxx IDENTIFIED EXTERNALLY will allow the user to be authenticated by the OS. REMOTE_OS_AUTHENT=TRUE specifies that a usr can be authenticated by a remote os.
•