Managing Users

You can create, modify, and delete users.

This section covers the following topics:

Creating a User

To create a new user, select the Users node or Schemas node in Server Explorer, then select New User. The User Designer appears.

See Also

User Designer

Modifying a User

To modify a user, select the Users node or Schemas node in Server Explorer. Select the user to modify, right-click, and select Edit. The User Designer appears.

See Also

User Designer

Deleting a User

To delete a user, select the Users node or Schemas node in Server Explorer. Select the user to delete, right-click and select Delete. When the confirmation message appears, select Yes.

Note:

Only a user that has been granted the DROP USER system privilege can drop other users. A connected user cannot be deleted.

See Also

User Designer