Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

User Passwords

Images Database administrators are primarily responsible for managing user IDs within the database. These statements allow administrators to determine the access rights and other security properties for a database account, including the password:

  • CREATE USER
  • ALTER USER
  • DROP USER

As you might expect, only an administrator may create and drop database users, or alter their account properties. And users are prohibited from altering their own account properties without special authorization. However, any user may alter their own password using the IDENTIFIED BY option of the ALTER USER command. This is shown in the example below.

Images

Note that for Oracle 11g and later releases of the database, password checking is generally case-sensitive, although the administrator could disable this option if desired.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint