Privileges are granted to a specific user ID. Once the user ID is established, an individual can log into the system using that user ID containing the granted privilege.
To grant privileges to a new user (one not already listed in the Security tab):
- Connect to a database as a user who has DBA privileges.
- Choose the Security node in the DB Structure view. The Security tab appears in the DB Detail view.
-
Click Add SQL Privilege
in the Security tab. The Add SQL Privilege dialog appears.
- Type a user ID. The user ID can contain a maximum of 32 characters and cannot contain any blanks.
- Choose either DBA or RESOURCE privileges for the user. In SQL, DBA and RESOURCE are database-wide privileges that can be assigned to individual users. Users with DBA privileges have the ability to access, modify, or delete a database object and to grant privileges to other users. RESOURCE privileges are limited compared to DBA privileges. Users with RESOURCE privileges can create database objects, but cannot modify or delete database objects. They cannot grant privileges to other users.
- Click Create. This generates, executes, and commits a SQL script. The new user appears in the list in the Security tab and is an authenticated user listed in the _User table.