HP 3000 Manuals HP 3000 Manuals
Summary of Commands to Change Database Security DBChange Plus provides specific commands to change and review database security. Some deal only with database security, while others are multipurpose commands. For example, CHANGE ITEMSECURITY only makes changes to data item security; while CHANGE ITEM includes other data item changes in addition to data item security. If you are making several changes to a data item, then CHANGE ITEM is a more efficient command than CHANGE ITEMSECURITY. However, if you are making only data item security changes, then CHANGE ITEMSECURITY is a better choice. This chapter discusses only those commands that deal specifically with security. For more information about how to use multipurpose commands, refer to chapter 4, "Changing Data Items," or chapter 5,"Changing Data Sets." Table 7-1 alphabetically lists all DBChange commands that involve database security and summarizes their functions.
NOTE * Before invoking any of the following commands, you must log on to the system as the database creator, run the DBCPLUS program, and specify the database for which you want to change security. Refer to chapter 1, "Introduction to DBChange Plus." * The commands are not actually applied until the DBAPLUS program is used. Refer to chapter 9, "Applying Changes to the Database Structure."
Table 7-1. Summary of Commands to Change Database Security ---------------------------------------------------------------------------------------------- | | | | | Command | Keyword | Description | | | | | ---------------------------------------------------------------------------------------------- | | | | | ADD | ITEM | Adds a data item to the database. (Multipurpose | | | | command.) | | | | | | | PASSWORD | Adds a password and user class number to the | | | | database. | | | | | | | SET | Adds a new master or detail data set to the | | | | database. (Multipurpose command.) | | | | | ---------------------------------------------------------------------------------------------- | | | | | CHANGE | ITEM | Changes the type, length, subcount, security, | | | | and/or order of a data item. (Multipurpose | | | | command.) | | | | | | | ITEMSECURITY | Changes user class access to a data item. | | | | | | | PASSWORD | Changes a password. | | | | | | | SETSECURITY | Changes user class access to a data set. | | | | | ---------------------------------------------------------------------------------------------- | | | | | DELETE | ITEM | Deletes a data item and all associated fields and | | | | paths from the database. | | | | | | | ITEMSECURITY | Deletes all security specifications from a data | | | | item. | | | | | | | PASSWORD | Deletes a password and its associated user class | | | | from the database. | | | | | | | SET | Deletes a data set and all associated paths from | | | | the database. (Multipurpose command.) | | | | | | | SETSECURITY | Deletes all security specifications from a data | | | | set. | | | | | ---------------------------------------------------------------------------------------------- | | | | | PRINT | SCHEMA | Prints the database schema including changes. | | | | (Multipurpose command.) | | | | | ---------------------------------------------------------------------------------------------- | | | | | RECOVER | ITEM | Cancels a data item deletion. (Multipurpose | | | | command.) | | | | | | | SET | Cancels a data set deletion. (Multipurpose | | | | command.) | | | | | ----------------------------------------------------------------------------------------------