Adding a Datacom SQL AUTHID

Products

• Datacom
• Datacom/AD

Issue/Introduction

Each table that is SQL-able needs to have an AUTHID (Schema Authorization-id) .

SYSUSR and SYSADM are system authorization-ids that are created during the Datacom installation .

This article explains how an AUTHID can be added in batch.

Environment

CA Datacom all versions

Resolution

An AUTHID can be added by running DBSQLPR using SYSIN card CREATE SCHEMA  AUTHORIZATION name ;

or by running DDUPDATE

-USR DATACOM-INSTALL,NEWUSER

-BTG AUTHORIZATION,name

1500 AUTH-USAGE,S

-END

-UPD AUTHORIZATION,name(0001),PROD

-END