Table of contents

• Security restrictions settings

DBeaver allows the configuration of database connections with specific security settings. This can be done during the initial setup of a new connection or while editing an existing one.

Security restrictions settings

Within the Security section of the connection configuration, the following options are provided:

1. Read-only connection: This setting, when enabled, restricts the connection to read-only operations, ensuring no data can be modified or deleted.

   Tip: Alternatively, you can use the toolbar icon Make [database name] read-only () to quickly toggle this mode.

2. By clicking on the Edit permissions, you can access additional security settings:

Setting option	Description
Restrict data edit	Disables the ability to modify data within the database through this connection.
Restrict structure edit	Prohibits alterations to the database structure, such as tables or indices.
Restrict script execute	Prevents script execution, safeguarding against potentially harmful actions.
Restrict data import	Blocks the import of data from external sources into the database.

Tip: For additional settings and restrictions, especially for administrative purposes, refer to documentation on admin preference restrictions.