IDMS GRANT SIGNON DB003026 Resource SYSTEM SYST0002 has not been defined

Products

• IDMS

Issue/Introduction

Trying to GRANT SIGNON ON SYSTEM but getting this error:

     GRANT SIGNON ON SYSTEM SYST0002 TO userid;                                               
Status = -4       SQLSTATE = 28605        Messages follow:             
DB003026 C-4M6008: Resource SYSTEM SYST0002 has not been defined       

Environment

Release : 19.0

Component : CA IDMS/DB

Resolution

The system name to use is the one in the the SYSGEN SYSTEM statement definition in the  SYSTEM ID clause. For example: SYSTEM ID IS SYST0002

Before doing the grant, connect to SYSTEM:

CONNECT TO SYSTEM;
GRANT SIGNON ON SYSTEM SYST0002 TO userid;         

If this a new system, first define it to security, then do the GRANT:

CONNECT TO SYSTEM;
CREATE RESOURCE SYSTEM SYST0002;
GRANT SIGNON ON SYSTEM SYST0002 TO userid;            

To see which users have been granted signon privilege to the system use the command:

DISPLAY PRIVILEGES ON SYSTEM SYST0002;

 

Additional Information

See the IDMS documentation sections Security Administration, GRANT Signon Privilege, Syntax for Security Display Statements, Display Privileges on a System Resource.