When upgrading from a version previous to CA Datacom/DB Release 8.0, all tables are assigned an AUTHID of SYSUSR. To access these tables, you must use the full SQL name. For example, a table with the SQL name of PAYROLL would be accessed by entering SYSUSR.PAYROLL.
Important! Do not relate any PERSON occurrence to the SYSUSR AUTHORIZATION occurrence with the Default Authorization Panel, the SET commands, or using the online facilities with the PER-ATZ-AUTHID relationship.
Note: When CA Datacom Datadictionary is initially installed, there are only two schemas: SYSADM for CA Datacom system tables and SYSUSR, as previously noted, for upgraded tables.
If the CA Datacom/DB Security Facility is installed, the SYSADM AUTHID can be used by a global database owner to create the first user schema after installation, but we recommend that you do not use SYSADM as an AUTHID thereafter. See the CA Datacom Security Reference Guide for information on global database owner status.
|
Copyright © 2014 CA.
All rights reserved.
|
|