User Manager

Data Tool's User Manager allows you to add, edit, and drop users. It also allows you to grant or remove permissions globally, on the selected database, or on the selected object.

How to add a user

  1. Select a table in the SQL Console window's object list.
  2. Click the Users button below the object list. The User Manager dialog appears.

    3. User Manager

  3. Click the Create button to open the add dialog.
  4. Enter a user name and password.

    5. User Manager Add User

  5. Click 'Add' and the CREATE USER statement will be generated.
  6. Click 'Go' to replace the generated DDL into the SQL Console, close the editor, and run the statements.

How to grant a privilege

  1. Select a table in the SQL Console window's object list.
  2. Click the Users button below the object list. The User Manager dialog appears.
  3. In the User Manager, click on a user in the left list, a level in the center list, and then double-click grants in the right-most list. SQL is generated for new grants or revokes.
  4. Click 'Go' to replace the generated DDL into the SQL Console, close the editor, and run the statements.

Back to Table of Contents.