Granting Access to Tables › Assigning Passkeys › Giving Passkeys › Step 2: Giving Data Access and BROWSE Passkeys

Step 2: Giving Data Access and BROWSE Passkeys

The Give Passkeys screen lists all the passkey types in three columns: the data access passkeys are on the left, the catalog access passkeys are in the middle, and the predefined passkey combinations are listed on the right.

Determine Needs

Passkeys can be assigned either for individual tables, a user's ID (gives access to all of the user's tables), or a folder (CA-ICMS users only). Fran wants to assign data access passkeys for individual tables. Fran determines each user's needs as follows:

• Karen Cross needs to add and change rows in the JOB table.
• John Forrest needs to add and change rows in the APPLICANT table.
• Stan White needs to display the JOBS AND APPLICANTS view and to derive the INTERVIEW SCHEDULE view from the APPLICANT table.

The data access passkeys that Fran assigns to each user are shown below:

Need BROWSE for Data Access

In addition to the data access passkeys, Fran must also give the users a BROWSE passkey that enables them to access the individual tables from her directory. The BROWSE passkey is a catalog access passkey that allows users to select tables from a directory. You must give a user a BROWSE passkey, which allows access to your directory, before the user can access any tables in your directory. Like the data access passkeys, the BROWSE passkey can be given for an individual table or for your user name.

When given for an individual table, the BROWSE passkey must be accompanied by data access passkeys in order to access the table. When given for a user name, the BROWSE passkey enables you to list the contents of the user's directory. Again, in order to access any of the tables in the directory, you must have data access passkeys for the tables.

In this example, Fran decides to give data access and BROWSE passkeys for individual tables. She begins by assigning passkeys to user CROSS for access to the JOB table:

1. Fran types x next to Add, Modify, and Browse to give those passkeys.
2. She moves the cursor to the Give The Passkey(s) To This User Or Group field and types the name of the user to whom she is assigning passkeys; Fran types cross in this field.
3. In the For Access To The Following Entry field, Fran types the table name job.
4. She leaves the default value snell in the The Owner Of The Entry Is field because user SNELL is the owner of the JOB table.

                                            CA
  GPAS   CA - Automatic System Facility          *** Give Passkeys ***
 DC422007 SELECT AN ACTION

                                                        _ PF1 - Help
    Select Passkey Type(s):

     _ Copy        x Browse          _ DBA
     _ Create      _ Management      _ Read
     x Add                           _ Alter
     x Modify                        _ Write
     _ Erase                         _ Update
     _ Redefine                      _ All
     _ List

    Give The Passkey(s) To This User Or Group:

     cross

    For Access To The Following Entry:

     job

    The Owner Of The Entry Is: SNELL

Fran presses [Enter] to give the ADD, MODIFY, and BROWSE passkeys to ASF user Karen Cross. Karen Cross now has access to Fran's JOB table. She can display the table definition and the table's rows, and she can add and modify rows in the table.

To give the passkeys to the other ASF users, Fran changes the appropriate entries on the Give Passkeys screen to give John Forrest access to the APPLICANT table and give Stan White access to the APPLICANT table and to the JOBS AND APPLICANTS view.