Using CA IDMS Internal Security › CA IDMS Resources › Database Resources

Database Resources

What is a Database Resource

A database resource is an entity associated with the definition of or access to a database.

Database Resource Types

The following table shows the database resources type and the corresponding resource type keywords used in the SRTT and security information databases:

Securing Database Resources

If you specify internal security for the database (DB) resource type, you automatically secure the other resource types listed with DB in the preceding table.

You can grant privileges on the individual resource types, but you cannot turn security off in the SRTT for the resource types that are grouped with DB when DB is secured.

Database Occurrence Overrides

Using an occurrence override in the SRTT, you can specify a security option for an individual database associated with the system dictionary. For example, in one SRTT entry you can specify no security (the default) for resource type DB and in another entry specify internal security for the production database.

Ownership

Ownership is an attribute of an SQL schema. A user who issues a CREATE SCHEMA statement owns the schema that is created.

A schema owner implicitly holds all access and definition privileges on the tables, functions, procedures, table procedures, views, and access modules associated with the schema. The owner also has the authority to grant those privileges to others.

An owner cannot grant ownership to another user but can transfer ownership. In this way, ownership and its privileges are relinquished to the other user.

The DBMS does not check for ownership. It requests a check for a specific privilege such as SELECT privilege on a table, and the security system returns a positive response if the user in question is the owner of the object.