An SQL authorization ID is a entity-occurrence of the AUTHORIZATION entity-type which was created using a CREATE SCHEMA statement. An AUTHORIZATION occurrence created through another mode of CA Datacom Datadictionary or through batch transactions cannot be an SQL authorization ID.
When the AUTHORIZATION occurrence is created (using CREATE SCHEMA), the AUTH-USAGE attribute is assigned a value of S, indicating this occurrence is an SQL authorization ID.
An AUTHORIZATION occurrence marked for use by SQL can be related to one or more PERSON occurrences (user signon ID) with the PER-ATZ-AUTHID relationship. This is a many-to-one relationship, meaning that several PERSON occurrences can be related to a specific AUTHORIZATION occurrence. Several users can have the same default, but each user can have only one default. See Relating the Person to the AUTHID.
Important! Do not relate a PERSON occurrence to the SYSUSR AUTHORIZATION occurrence using the PER-ATZ-AUTHID relationship.
|
Copyright © 2014 CA.
All rights reserved.
|
|