Adding a Datacom SQL AUTHID
search cancel

Adding a Datacom SQL AUTHID

book

Article ID: 58309

calendar_today

Updated On:

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