Managing security restrictions for database connection
DBeaverDevOps edited this page Feb 9, 2024
·
1 revision
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.
Within the Security section of the connection configuration, the following options are provided:
-
Read-only connection: This setting, when enabled, restricts the connection to read-only operations, ensuring no data can be modified or deleted.
-
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.
-
Views
-
Search
-
Projects
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
- Tableau integration
- Transactions
- Drivers
- Tasks
- Cloud Explorer
- Cloud Storage
- Classic
- Cloud
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation