Authority-Based Users

Add, change, and delete users.

Users are objects within the database.

• Creating an Authority-Based User
  Add a new user to the database using the Create User wizard.
• Deleting an Authority-Based User
  Delete a user from the database.
• Converting an Authority-Based User to a Group
  Change an existing user into a group that retains the user’s authorities.
• Viewing or Modifying Authority-Based User Options
  View or change database option settings assigned to a user.
• Generating Authority-Based User DDL Commands
  Display the SQL data description language for creating a user. The SQL code can be a useful reference and training tool.
• Viewing or Modifying Authority-Based User Properties
  View or change the details of login parameters and authorities for authority-based users.
• Changing an Authority-Based User Password
  Change the password for another authority-base user.
• Forcing an Authority-Based User to Change their Password
  Force an authority-based user to change their password on next log in.
• Unlocking an Authority-Based User Account
  Unlock a locked authority-based user account.
• Changing an Authority-Based User Login Policy
  Assign an authority-based user a different login policy
• Adding an Authority to an Authority-Based User
  Add authorities to a user to allow him or her to perform specified database operations, such as the ability to manage dbspaces.
• Removing an Authority from an Authority-Based User
  Remove a user's ability to perform specific authorized database operations.
• Authority-Based User Privilege Summary
  A list of the system privileges and object permissions required to complete the various authority-based user tasks.