Author: Akhil Johny

Filter Database Objects in DBeaver

In the Database Navigator and Database Object Editor you can filter database objects to include or exclude some of them from the view. You can filter connections, schemas, tables, views, and procedures. A dots sign (…) next to the node`s name indicates that a filter is applied to its sub-nodes:  To filter objects by name, type the object name in the… Continue reading Filter Database Objects in DBeaver

Predefined Roles in postgreSQL

PostgreSQL provides a set of predefined roles that provide access to certain, commonly needed, privileged capabilities and information. Administrators (including roles that have the CREATEROLE privilege) can GRANT these roles to users and/or other roles in their environment, providing those users with access to the specified capabilities and information. The predefined roles are described in Table 21.1. Note that the specific permissions… Continue reading Predefined Roles in postgreSQL

Role Membership in postgreSQL

It is frequently convenient to group users together to ease management of privileges: that way, privileges can be granted to, or revoked from, a group as a whole. In PostgreSQL this is done by creating a role that represents the group, and then granting membership in the group role to individual user roles. To set up a group role,… Continue reading Role Membership in postgreSQL

Role attributes in postgreSQL.

A database role can have a number of attributes that define its privileges and interact with the client authentication system. login privilege Only roles that have the LOGIN attribute can be used as the initial role name for a database connection. A role with the LOGIN attribute can be considered the same as a “database user”. To create a role… Continue reading Role attributes in postgreSQL.

PostgreSQL database role

Database roles are conceptually completely separate from operating system users. In practice it might be convenient to maintain a correspondence, but this is not required. Database roles are global across a database cluster installation (and not per individual database). To create a role use the CREATE ROLE SQL command: CREATE ROLE name; name follows the rules for SQL… Continue reading PostgreSQL database role

Background Tasks in DBeaver

Background tasks in DBeaver are operations that run behind the scenes, allowing you to continue working without disruption. These tasks can involve a range of operations, such as data transfer and SQL script execution, amongst others. You can open the Background Tasks view from the main menu by clicking Window -> Show View -> Other. In the Show View window, click Background Tasks, and then click Open: The Background Tasks view… Continue reading Background Tasks in DBeaver

UI Language in Dbeaver

The interface language of DBeaver can be customized to suit your preferences. There are two methods to achieve this: Changing interface language in preferences Navigate to Window -> Preferences -> User Interface. Choose your desired language from the drop-down menu. Click the Apply and Close button to save your settings. Note: If DBeaver is installed in a directory… Continue reading UI Language in Dbeaver

Change DBEAVER THEME

1) Go to Window -> Preferences -> User Interface -> Appearance. 2) Select from the following available themes: Light Dark Classic Note: To fully apply the selected theme, you must restart DBeaver. Managing the High Contrast theme in Windows Windows users have the additional option of using High Contrast themes. This section provides details on… Continue reading Change DBEAVER THEME

Database full text search in Dbeaver

To do a full text search in the database, click the arrow next to the Search icon in the main toolbar and then click File Search on the dropdown menu: Alternatively, you can click the Search button on the main menu and then click the DB Full-Text tab in the Search window: Now you need to choose the database connection or… Continue reading Database full text search in Dbeaver