UNIT 7

SQL/PRO Security

Accessing SQL/PRO Security

Make sure that you are signed on as security officer (QSECOFR) and have added the library SQLPRO to your library list. Enter STRPDSQL on the command line. Now press F13 for the Services menu.

Figure 7.1

Option 7: Security will appear at the bottom of the list. Take option 7 to work with security settings.

Figure 7.2

When you elect to do an Add or Change the next screen appears. Place a "Y" or "N" in each field to denote the functions that the profile will have access to.

Figure 7.3

*PUBLIC is the default user profile. It is initially set up to have all authorities. This profile is used as the default if a user's individual or group profile is not found.

When a user starts SQL/PRO the security program will first look for the user profile then the group profile of the person signing on. The profile being used will appear in the upper right hand corner of the main SQL/PRO screen.