IBM Support

How to grant/revoke access to IBM Spectrum Protect server database TSMDB1

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<

[{"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":"BU054","label":"Systems 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":"BU054","label":"Systems w\/TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg22015625