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 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 .