The CA Dataquery Administrator has the responsibility of authorizing users for personal database and for naming the area in CA Datacom/DB. See Authorizing Users.
When a user is added with a private SQL authorization specified, 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 using the Personal Database Facility are automatically added to the schema for the authorization ID specified when the user creates the SQL object.
|
Copyright © 2014 CA.
All rights reserved.
|
|