Using External Security for CA Datacom › CA Dataquery and External Security › PDB and STORE Considerations

PDB and STORE Considerations

Here are some considerations for the use of PDB (personal data base) and the STORE command. With these functions and by using SQL, tables are created in an area specified in your profile (this profile information is still used even when external security is in effect for CA Dataquery). The area must be in a database for which you have both create authority and CA Dataquery authority to do maintenance. The area and database should be built separately for each user or group of users that are allowed PDB authority, so that these tables are not put into any arbitrary database.

Note: For more information about how to set up a database for SQL use, see the CA Datacom/DB Database and System Administration Guide.

When external security is in effect, you must have full access rights to the database where personal tables are created (for PDB or STORE). This includes CREATE and DROP authority, that is, cxxname.DBdbid.999.CATALOG. This is the reason that we recommend separate databases for each group of users that can have access to each other's tables. The authority to specify in the external security package is cxxname.DBdbid (with required generics) to allow PDB and STORE to function properly.

Note: For more information about using PDB, see the CA Dataquery Administrator Guide.