Professional

Users and roles

In the Database tool window (View | Tool Windows | Database), right-click a data source node and navigate to New | User or New | Role.

For some databases, you need to specify a database where you want to create a role or a user. In this case, you must expand the data source tree to the database node, right-click the database node and select New | User or New | Role.

Select the necessary database settings. In the Preview pane, you can change the generated SQL code.

Click OK.

To see your changes, press Ctrl+F5.

In the Database tool window (View | Tool Windows | Database), right-click an object and select Modify <Object>.

On the Grants tab, click the Add button ().

In the user field, type the username. You can press Ctrl+Space to use code completion in this field.

Click the grant field, from the drop-down near each privilege, select Grant or Grant with option. The Grant with option privilege means that a user can grant to or revoke from other users those privileges.

In the Database tool window (View | Tool Windows | Database), right-click a user or a role and select Modify Role.

In the Grants section of the Modify dialog, add () or remove () permissions to database objects.

You can use auto-completion for database objects.

Click the grant field, from the drop-down near each privilege, select Grant or Grant with option. The Grant with option privilege means that a user can grant to or revoke from other users those privileges.