Table
The table resource type represents base tables, functions, procedures, table procedures and views.
A view is a logical table derived from information in one or more base tables, table procedures or views. CA IDMS centralized security does not distinguish between table-like objects, but special security considerations pertain to view access.
Note: For more information, see Securing Views.
Access Module
The access module resource represents a set of precompiled SQL statements. The owner of the access module must hold all necessary table access privileges in order to execute the access module. The access module owner can grant execution privilege to other users if the owner holds grantable table access privileges.
Note: For a more detailed discussion of access module security, see Runtime Security for Access Modules.
Schema
The schema resource is equivalent to the ANSI SCHEMA construct. All tables, functions, procedures, table procedures, views, and access modules are contained within a schema. The schema name becomes the high-level name qualifier for all subordinate entities.
The schema also designates ownership of resources. The owner of a schema owns all resources within the schema. Ownership is established when the schema is created.
|
Copyright © 2014 CA.
All rights reserved.
|
|