DB2 for LUW DBA Tools - Security Manager

Provides manageability of users, roles,and groups allowing the user to manage permissions, roles and security of the DB2-LUW database.

Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available.

Available operations for Tree tab
Refresh: Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Expand All: Expands all tree nodes in the tree tab
Collapse All: Collapses all tree nodes in the tree tab
Create User: Creates a new user
Alter User: Edits selected user
Drop User: Drops selected user
User Properties: Shows properties of selected user
Create Role: Creates a new role
Alter Role: Edits selected role
Drop Role: Drops selected role
Role Properties: Shows properties of selected role
Create Group: Creates a new group
Alter Group: Edits selected group
Drop Group: Drops selected group
View Group: Shows properties of selected group

Available operations for Users tab
Refresh : Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else
Create User: Creates a new user
Alter User: Edits selected user
Drop User: Drops selected user
View User: Shows properties of selected user

Available operations for Roles tab
Refresh : Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else
Create Role: Creates a new role
Alter Role: Edits selected role
Drop Role: Drops selected role
Role Properties: Shows properties of selected role

Available operations for Groups tab
Refresh: Refreshes all tabs in the security manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else
Create Group: Creates a new group
Alter Group: Edits selected group
Drop Group: Drops selected group
View Group: Shows properties of selected group

Logins & Server Roles Tab - Provides a tree display of users, roles and groups from the DB2-LUW database. Selecting an object in the tree structure will display a detailed view of the object on the right pane.

DB2 for LUW DBA Tools - Security Manager - Logins and Server Roles Tab


 

Users Tab - Provides a list of users in the DB2-LUW database

Name: Name of the user


DB2 for LUW DBA Tools - Security Manager - Users Tab


 

Roles Tab - Provides a list of roles in the DB2-LUW database

Name: Name of the role
Authentication: Authentication of the role


DB2 for LUW DBA Tools - Security Manager - Server Roles Tab

Groups Tab - Provides a list of Groups in the DB2-LUW database

Name: Name of the group
Authentication: Authentication of the group


DB2 for LUW DBA Tools - Security Manager - Server Groups Tab



  • No labels