Session 3: Database Security Management

Go Up to DBArtisan Tutorial exercises

DBArtisan helps you efficiently establish and maintain database security. Whether you are managing an existing production database or setting up a new environment, you’ll find consistent support across all supported platforms.

Adding a new database user

While this example focuses on creating a new Oracle user, the same wizard-driven principle applies to all security objects (groups, roles, etc.).

To create a new user

1. On the Datasource Explorer, expand an Oracle datasource, and then the Security node.
2. On the Security node, right-click Users, and then click Create. DBArtisan opens the Create User wizard and leads you through the process of adding a user.

   

3. Provide the information on each panel of the Create User wizard until you reach the DDL View panel. DBArtisan allows you to preview any and all generated scripts before submitting to the database. This is standard for all object-related scripts.
4. Click Execute to create the new user. DBArtisan automatically opens the User Editor for the new user. Use the standard User Editor to manage existing database users as shown below.

Granting and Editing User Privileges

You can easily grant, revoke, or view privileges from within either of following two editors within DBArtisan:

• the User Editor
• the individual object editor (Table, Procedure, etc.)

The User Editor provides a tabbed interface, which makes it simple to view and modify individual attributes of the user.

To manage user privileges

1. In the User Editor, select the Object Permissions tab.
2. Use the Object Type dropdown to select a set of objects, such as tables or views.
3. Right-click a cell (corresponding to a specific object and a specific permission, such as DELETE), and then click Grant. This step adds a distinctive icon to the cell, indicating that this permission is granted. Use a similar process to revoke privileges and perform other permission-based activities.
4. On the Object Editor toolbar, click Alter to implement the changes.

Proceed to Session 4: Space Management.