Users
A database user is a security principal enabling object access permission control at the finest level of granularity. A user represents a single server login within the scope of the database in which the user is defined.
To create a new user:
- Select the Database | New Object... menu item.
- Select User in the New Object Dialog.
- Edit user definition within the User Manager.
Hint: To create new user you can also right-click the Users node of the explorer tree and select the New User... item from the popup menu.
To create a new user with the same properties as one of the existing users has:
- Select the Database | Duplicate Object... menu item.
- Follow the instructions of the Duplicate Object Wizard.
To edit the existing user:
- Select the user for editing in the explorer tree (type the first letters of the user name for quick search).
- Right-click and select the Edit User <User_Name> item from the popup menu or simply double-click the user.
- Edit user definition and data on the appropriate tabs of the User Manager.
To change the name of the user:
- Select the user to rename in the explorer tree.
- Right-click and select the Rename User <User_Name> item from the popup menu.
- Edit user name in the dialog window.
To drop a user:
- Select the user to drop in the explorer tree.
- Right-click and select the Drop User <User_Name> item from the popup menu.
- Confirm dropping in the dialog window.
