Previous Topic: Securing DBADMINNext Topic: Securing DMCLs


Securing Areas

About Areas

When you secure resource type DB, you can control who can access an area through a CA IDMS utility and who can create tables and indexes to be stored in the area. Until you secure resource type DB, any user can access an area through a CA IDMS utility and create tables and indexes to be stored in the area.

How to Secure Areas

You secure areas by securing the DB resource.

Note: For more information, see Securing Databases.

If you secure areas externally, you must also include an entry in the SRTT with external security information for resource type AREA.

How to Grant Area Access and Use Privileges

To give area access privileges, you issue a GRANT statement on the area resource type, specifying the privilege or privileges and identifying the area. You can specify any combination of DBAREAD, DBAWRITE, and USE privileges.

DBAREAD and DBAWRITE privileges allow read-only and read-write access to an area using CA IDMS Utilities.USE privilege allows creation of a table or index in the area.

As a holder of SYSADMIN or DBADMIN privilege, you can specify WITH GRANT OPTION when you grant these privileges to allow the user to grant the same privileges to another user. You must be connected to the system dictionary.

More Information: