Role-Based Users

Add, change, and delete role-based users.

• Creating a Role-Based User
  Add a new role-based user to the database using the Create User wizard.
• Deleting a Role-Based User
  Delete a role-based user from the database.
• Converting a Role-Based User to a User-Extended Role
  Change an existing user to act as a role. The user-extended role retains membership roles already granted to the user.
• Adding a Role to a Role-Based User
  Add a role-based user a member of a role. The user inherits all underlying system privileges and roles of the granted role.
• Changing a Role-Based User's Administrative Rights on a Role
  Change a role-based user's ability to manage a role.
• Removing a Role from a Role-Based User
  Remove a role-based user's membership in a role.
• Adding a System Privilege to a Role-Based User
  Allows a role-based user to perform privileged tasks associated with a system privilege.
• Changing a User's Administrative Rights on a System Privilege
  Changes a user's ability to manage a system privilege.
• Removing a System Privilege from a Role-Based User
  Remove a system privilege from a role-based user.
• Viewing or Modifying Role-Based User Options
  View or change database option settings assigned to a user.
• Generating Role-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 Role-Based User Properties
  View or change user properties such as password, login policy and database object permissions.
• Changing a Role-Based User Password
  Change the password for another role-base user.
• Forcing a Role-Based User to Change their Password
  Force a role-based user to change their password the next time he or she logs in.
• Unlocking a Role-Based User Account
  Unlock a locked role-based user account.
• Changing a Role-Based User Login Policy
  Assign a role-based user a different login policy
• Role-Based User Privilege Summary
  A list of the system privileges and object permissions required to complete the various role-based user tasks.