Access to another user's personal tables can be convenient for both users. For example, if an office manager maintains weekly status reports on his personal database and he wishes a secretary to compile a monthly report, the CA Dataquery Administrator can give the secretary access to the manager's tables.
The user must be authorized to access (read, update, insert, or erase) these tables just like any other CA Datacom/DB table.
To give another user access to someone's personal tables, simply provide the authorization ID. In SQL Mode, the creator of the table may give another user access to his personal tables by using the SQL GRANT command. See the CA Datacom/DB SQL User Guide. If access through SQL Mode query or dialog is needed, the user can supply the authorization ID as part of the table name, as in:
FROM authid.table-name
The user cannot change his private SQL authorization ID. They may change the currently used authid, but it will not be used by the PDB facility. CA Datacom/DB Security, including GRANT, will govern accessibility of another user's tables, whether the authid is known and supplied, or not.
|
Copyright © 2014 CA.
All rights reserved.
|
|