What are the checks that occur out of TSSDB2 when a users invokes a Stored Procedure?
search cancel

What are the checks that occur out of TSSDB2 when a users invokes a Stored Procedure?

book

Article ID: 12970

calendar_today

Updated On:

Products

Top Secret Top Secret - LDAP

Issue/Introduction

What are the checks that occur out of TSSDB2 when a users invokes a Stored Procedure?
Is there more than one call associated with the one action of the invoke of the DB2PROC?

Environment

Release: TOPSDB00200-1.3-Top Secret-Security-Option for DB2 UDB
Component:

Resolution

The following checks are issued by TSS/DB2 when executing a Stored Procedure:
- EXECUTE Privilege on STORED PROCEDURE is allowed via:

DB2PROC(xxxxx) ACCESS(EXECUTE)
DB2SYS(SQLADM)
DB2SYS(DBADM)
DB2SYS(DATAACC)
DB2SYS(SYSADM) 

Additional Information