Program for resource security in a database management system
An inventive method is presented for resource security in a database management system having a plurality of resources, the method comprising creating a macro and a corresponding data section definition (DSECT) defining security for each resource, assembling all of the DSECTs into a load module, processing the load module to obtain source code, and assembling the source code, such that changing the source code of one resource modifies the defined security of the resource and adding new source code to the source code adds a new resource having security to the plurality of resources. The processing step can comprise loading the load module, reading a DSECT having a total number of resources, and, for each resource of the total number of resources, reading a next DSECT, finding the defined security in the next DSECT, and obtaining the source code associated with the defined security.
1. A method for resource security in a database management system having a plurality of resources, comprising steps of:
for each resource in the database management system, defining a security for the resource by creating a macro and a corresponding data section definition;
converting the macros into a collection of hexadecimal strings;
assembling all of the data section definitions and the converted macros into a load module;
processing the load module to obtain the macros, the processing comprising steps of:
reading, from the load module, a first data section definition;
retrieving, from the first data section definition, a total number of resources; and
for each resource of the total number of resources:
reading a next data section definition;
finding the defined security in the next data section definition; and
generating the macro associated with the defined security; and
after processing the load module, modifying the macros obtained through the generating the macro operations by performing at least one of: changing the macro of one resource to modify the defined security of the one resource, or adding a new macro defining security for an additional resource; and
assembling the modified macros to obtain a new load module that includes security information for the resources in the database management system.
2. The method according to claim 1 , wherein the data section definition comprises a type selected from one of INITIAL, FINAL, ENTRY, and OCCURRENCE.
3. The method according to claim 1 , wherein the data section definition comprises a resource name, a resource type, and an external name.
4. The method according to claim 3 , wherein the external name is one of Activity, Application Name, Database Name, Data Definition Name, Environment, Resource External Name, Resource External Type, Schema, SSName, System, and Version.
5. The method according to claim 1 , wherein the defined security is one of not secured, internally secured, and externally secured.
6. The method according to claim 1 , further comprising the steps of:
creating a header macro and a corresponding header data section definition; and
creating a final macro and a corresponding final data section definition.
7. The method according to claim 6 , wherein the header data section definition comprises a type of INITIAL and at least one of an environment name, a system profile, a user profile, a user identifier, a service number, and a total number of resources.
8. The method according to claim 6 , wherein the final data section definition comprises a type of FINAL.