Question & Answer
Question
How can a user authority be added to / removed from the IBM Spectrum Protect server database TSMDB1?
Answer
In some circumstances a new user needs to get access to the TSMDB1 database and also existing users need to be removed.
Steps to do:
- Sign on as the instance user
- Run following commands:
- db2 connect to TSMDB1
- db2 "select grantee,securityadmauth from syscat.dbauth"
The output returns which user ID is authorized to the database, for example:
To add a user, run following commands:
- db2 grant dbadm with dataaccess with accessctrl on database to user >user to add<
- db2 grant secadm on database to user >user to add<
To remove a user, run following commands:
- db2 revoke secadm on database from user >user to remove<
- db2 revoke dbadm, DATAACCESS, ACCESSCTRL ON DATABASE FROM USER >user to remove<
Related Information
[{"Product":{"code":"SSER5J","label":"IBM Spectrum Protect Extended Edition"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.1;8.1","Edition":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}},{"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}},{"Product":{"code":"SSER5J","label":"IBM Spectrum Protect Extended Edition"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}},{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}},{"Product":{"code":"SSSQWC","label":"Tivoli Storage Manager Extended Edition"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg22015625