When a user is added with a private SQL authorization specified, such as is required for SQL use, CA Dataquery automatically creates a schema in CA Datacom Datadictionary for the SQL authorization ID. A schema defines the individual user's SQL environment. Users must have a schema associated with an authorization ID to use SQL. A schema contains all table, view and privilege definitions owned by a given authorization ID. Any definitions created by the user are automatically added to the schema for the authorization ID specified when he creates the SQL object.
AUTHIDs or schemas are not used for security. SQL security (CA Datacom/DB security) is based on accessor ID and not an AUTHID.
|
Copyright © 2014 CA.
All rights reserved.
|
|