Online Documentation for SQL Manager for Oracle

Users


A User is an account through which one can login to the database.

 

 

Creating Users

To create a new user:

Hint: To create a new user, you can also right-click the Users node or any object within this node in the DB Explorer tree and select the New User item from the context menu.

 

To create a new user with the same properties as one of existing users has:

Alternatively, you can right-click a user in the DB Explorer tree and select the Duplicate User <user_name>... context menu item.

 

Duplicate Object Wizard allows you to select the database to create a new user in, and to edit the result SQL statement for creating the user.

 

Editing Users

  • select the user for editing in the DB Explorer tree (type the first letters of the user name for quick search);
  • right-click the object and select the Edit User <user_name> context menu item, or simply double-click the user;
  • edit user properties using the appropriate tabs of User Editor.

 

Dropping Users

  • select the user to drop in the DB Explorer tree;
  • right-click the object and select the Drop User <user_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new user;

Ctrl+O to edit the selected user;

Shift+Del to drop the object from the database.

 

See also:

Roles