Users/Roles

Creating a User/Role

A database is used by many users, and the users are grouped for management convenience. A database role represents a database user or a group of database users.

Users and roles have similar concepts in databases. In practice, you are advised to use a role to manage permissions rather than to access databases.

• Users: They are set of database users. These users are different from operating system users. These users can assign permissions to other users to access database objects.
• Role: This can be considered as a user or group based on the usage. Roles are at cluster level, and hence applicable to all databases in the cluster. A role is a cluster-level definition and applies to all databases in a cluster.

Dropping a User/Role

Right-click the selected user/role and select Drop User/Role.

Viewing/Editing User/Role Properties

Right-click the selected user/role and select Properties.

Data Studio displays the properties (General, Privilege, and Membership) of the selected user/role in different tabs. Editing of properties can be performed. OID is a non-editable field.

Viewing the User/Role DDL

Right-click the selected user/role and select Show DDL.

The user/role DDL is displayed in a new SQL Terminal tab. You must refresh the Object Browser to view the latest DDL.