Authentication PostgreSQL SSPI
DBeaverDevOps edited this page Apr 1, 2024
·
2 revisions
Note: This feature is available in Lite, Enterprise, Ultimate and Team editions only.
DBeaver comes with SSPI (Security Support Provider Interface) authentication support, allowing secure access to PostgreSQL databases. This authentication type enables Windows Single Sign-On (SSO), allowing users to authenticate using their existing Windows account credentials.
To configure SSPI authentication in DBeaver, follow these steps:
- From the Authentication dropdown menu, select the PostgreSQL SSPI method.
- For the authentication process, your system will utilize the relevant credentials automatically. On Windows systems,
your current login credentials are used, and on non-Windows platforms that support GSSAPI, the integrated
authentication system will apply.
Note: Your system (whether it's Windows or a non-Windows platform with GSSAPI support), and PostgreSQL server must be correctly configured for SSPI authentication. If you encounter any issues during this process, please follow the official PostgreSQL documentation. - Click Test Connection to confirm your settings. If the test is successful, your setup is complete.
-
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