Modify

Modify a 

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

2. In the Modify Table dialog, specify the settings that you need.

Modify a database-specific parameters of an object

1. In the Database tool window (View | Tool Windows | Database), right-click a and select Modify (New UI).

2. In the Modify dialog, specify object settings that you need.

Enable read-only mode for a table

To protect a table from accidental modifications in the data editor, you can make the table read-only.

• To enable read-only mode, click the Click to toggle the read-only attribute icon () in the lower-right corner of the editor.

To turn off read-only mode, click the Click to toggle the read-only attribute icon again.

Show descriptions for databases and tables

• To enable descriptions for databases and tables, navigate to View | Appearance | Details in Tree View.

  To add comments for tables, select a table and press Ctrl+F6. In the Comment text field, add a table description.

  To add comments for a database, open database settings Ctrl+Alt+S and add a database description in the Comment text field.

  

Configure GRANT privileges for tables

1. In the Database tool window (View | Tool Windows | Database), right-click a table and select Modify Table.

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

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

4. 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.

   

   Gif