CODEWITHSUNDEEP
databasedb2sqlclient
jikku
jikku

Reputation: 801

db2 database gui interface

Which database client tool (gui tool), can be used to view/modify the user permissions in a db2 database. The version is db2 v 11.1.

control center is discontinued as per the notes in publib. Installed squirrel sql, but not able to see a place/tool where we can grant/revoke permissions of a db user?

Upvotes: 0

Views: 6987

Answers (1)

data_henrik
data_henrik

Reputation: 17118

Permissions in Db2 are stored in the catalog. You can learn more about the Db2 security model from this part of the documentation. Giving a user permissions or deleting them is done via the GRANT and REVOKE statements. To find out which permissions exist, you can query the related catalog views.

IBM has two tools which provide a UI to those catalog entries and help with user management. These are IBM Data Studio and IBM Data Server Manager (DSM).

Upvotes: 1

Related Questions