HP 3000 Manuals HP 3000 Manuals
Table Security Menu
Table Security Menu
At the Table Security Menu (TS), the menu path you choose will let you
add, change, delete, or examine table security definitions. You define
table security with the Add/Delete Table Security by Table and Add/Delete
Table Security by Group screens as appropriate.
To handle table security definitions:
* Go directly to the screen you want by typing its screen name in
the Go to screen field of any menu and pressing Enter, or
* Choose a function label at the Table Security Menu (TS).
The Table Security Menu looks like this.
______________________________________________________________________________________________
| |
| |
| CONFIG Table Security Menu Screen: TS |
| Choose a function, or type in a screen name and press ENTER. |
| |
| |
| Add/Del by Table - Assign one or more access groups to a table. |
| |
| Add/Del by Group - Assign an access group to one or more tables. |
| |
| Show by Table - List all access groups assigned to a table. |
| |
| Show by Group - List all tables and access group has been assigned to. |
| |
| List Pub Tables - List all public tables you control. |
| |
| Change Default - Change the default table security assigned to new tables. |
| |
| Done - Return to the Security Menu. |
| |
| |
| Go to screen |
| |
| Add/Del Add/Del Show Show List Pub Chg Dflt Done |
| by Table by Group by Table by Group Tables Security |
| |
______________________________________________________________________________________________
Privileged Users.
When a PC user who is a member of a capability-2 or capability-3 access
group configures an IMAGE table, Access Server automatically adds table
security by assigning the user's access group to the table.
PC users who belong to a capability-3 access group can delete any
configured table (view, IMAGE, or file) to which their access group is
the only access group assigned.
Adding Table Security by Table
Add table security by table by assigning one or more access groups to a
table at the Add/Delete Table Security by Table (ADTST) screen, shown on
the next page. Only those access groups will have access to the table.
DBA Capabilities.
If you are the primary DBA, you can add table security for all tables.
If you are a secondary DBA, you can add table security only for the
tables you control.
______________________________________________________________________________________________
| |
| |
| CONFIG Add/Delete Table Security by Table Screen: ADTST |
| Type in the information and press ENTER. |
| |
| Table |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Help Done |
| |
| |
______________________________________________________________________________________________
To Add Table Security by Table:.
1. Go to the Add/Delete Table Security by Table screen by typing
ADTST in the Go to screen field of any menu, or by choosing
Add/Del by Table f1 at the Table Security Menu.
2. Type in the table name and press Enter.
A list of all access groups appears on the screen. The access
groups currently assigned to the table are indicated by an X in
the Sel field.
3. To select the access groups you want to add to the table, type an
X in the Sel field next to the access group name.
4. To add the access groups, press Enter.
The Administrator Utility adds the access group name to the table
security definition in the data dictionary.
5. To leave this screen, choose Done f8. This returns you to the
Table Security Menu. From there, you can go to another screen or
exit the utility.
In addition to using this screen to assign table security, you can use
the Add Item Security (AIS) screen to allow or deny access to particular
items in the table.
Deleting Table Security by Table
Delete table security by table by removing one or more unwanted access
groups from a table at the Add/Delete Table Security by Table (ADTST)
screen.
Impact on PC Users.
Removing an access group from the list of access groups assigned to a
table can have two different effects:
* If the access group being removed is the only access group
assigned to the table, then removing this access group turns the
table into a public table, accessible to all users. (Items within
the table may still have been secured using the Item Security
screens.)
* If there are other access groups assigned to the table, then
removing this access group prevents its users from accessing the
table.
CAUTION Before deleting table security, review your current Access
Server security to make sure you don't inadvertently create a
public table. For example, if configured table TABLE1 has only
one access group GROUP1 assigned to it, then deleting GROUP1
makes TABLE1 a public table until you assign some other access
group to it. Similar side effects are also possible with
secured items within tables.
DBA Capabilities.
If you are the primary DBA, you can delete table security for all tables.
If you are a secondary DBA, you can delete item security only for the
tables you control.
To Delete Table Security by Table.
1. Go to the Add/Delete Table Security by Table screen by typing
ADTST in the Go to screen field of any menu, or by choosing
Add/Del by Table f1 at the Table Security Menu.
2. Type in the table name and press Enter.
A list of all access groups appears on the screen. The access
groups currently assigned to the table are indicated by an X in
the Sel field.
3. To delete one or more access groups, type a space over the X in
the Sel field next to the access group name(s).
4. To leave this screen, choose Done f8. This returns you to the
Table Security Menu. From there, you can go to another screen or
exit the utility.
Adding Table Security by Access Group
Add table security by access group by assigning an access group to one or
more tables at the Add/Delete Table Security by Group (ADTSG) screen,
shown on the next page.
DBA Capabilities.
If you are the primary DBA, you can add table security for all tables.
If you are a secondary DBA, you can add table security only for the
tables you control.
______________________________________________________________________________________________
| |
| |
| CONFIG Add/Delete Table Security by Group Screen: ADTSG |
| Type in the information and press ENTER. |
| |
| Access Group |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Help Done |
| |
| |
______________________________________________________________________________________________
To Add Table Security by Access Group:.
1. Go to the Add/Delete Table Security by Group screen by typing
ADTSG in the Go to screen field of any menu, or by choosing
Add/Del by Group f1 at the Table Security Menu.
2. Type in the access group name and press Enter.
A list of all tables appears on the screen. The tables to which
the specified access group is currently assigned are indicated by
an X in the Sel field.
3. To select the tables you want to add to the access group, type an
X in the Sel field next to the table name.
4. To add the tables, press Enter.
The Administrator Utility adds the table names to the table
security definition in the data dictionary.
5. To leave this screen, choose Done f8. This returns you to the
Table Security Menu. From there, you can go to another screen or
exit the utility.
Deleting Table Security by Access Group
Delete table security by access group by removing an unwanted access
group from one or more tables at the Add/Delete Table Security by Access
Group (ADTSG) screen.
DBA Capabilities.
If you are the primary DBA, you can delete table security for all tables.
If you are a secondary DBA, you can delete item security only for the
tables you control.
To Delete Table Security by Access Group.
1. Go to the Add/Delete Table Security by Access Group screen by
typing ADTSG in the Go to screen field of any menu, or by choosing
Add/Del by Group f1 at the Table Security Menu.
2. Type in the access group name and press Enter.
A list of all tables appears on the screen. The tables to which
the specified access group is currently assigned are indicated by
an X in the Sel field.
3. To delete one or more tables, type a space over the X in the Sel
field next to the table name(s).
4. To leave this screen, choose Done f8. This returns you to the
Table Security Menu. From there, you can go to another screen or
exit the utility.
Changing Default Table Security
The Change Default Table Security Screen lets you indicate which access
group will automatically be assigned to the tables you configure.
To Change Default Table Security:.
1. Go the the Change Default Table Security screen by typing CDTS in
the Go to screen field of any menu, or choose Chg Dflt Security
f6 at the Table Security Menu.
2. The Change Default Table Security screen appears. The Table
Security field shows the name of the access group (if any)
assigned to you. If no access group name is shown, then all
tables you configure are public tables and are accessible to all
users.
3. To add or change the access group that will automatically be
assigned to tables you configure, type the access group name in
the Table Security field.
4. To put the change into effect, press Enter.
The table security definition in the data dictionary is updated to
reflect the change in security. The access group will
automatically be assigned to future tables you configure.
5. To leave this screen, choose Done f8. This returns you to the
Table Security Menu. From there, you can go to another screen or
exit the utility.
Examining Table Security Information
Examine information about table security at the Show Table Security by
Table (STST) screen, Show Table Security by Group (STSG) screen, and from
the List Public Tables (LPT) screen.
DBA Capabilities.
If you are the primary DBA, you can examine table security information
for all tables. If you are a secondary DBA, you can examine table
security information only for the tables you control.
______________________________________________________________________________________________
| |
| |
| CONFIG Show Table Security by Table Screen: STST |
| Type in the information and press ENTER. |
| Page of |
| Table |
| |
| Access Groups |
| |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| |
| Print Previous Next Go To Help Done |
| Page Page Page |
| |
______________________________________________________________________________________________
______________________________________________________________________________________________
| |
| |
| CONFIG Show Table Security by Group Screen: STSG |
| Type in the information and press ENTER. |
| Page of |
| Access Group |
| |
| Tables |
| |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| |
| Print Previous Next Go To Help Done |
| Page Page Page |
| |
______________________________________________________________________________________________
To Show Table Security for a Specific Table:.
1. Go to the Show Table Security by Table screen by typing STST in
the Go to screen field of any menu, or by choosing Show by Table
f3 at the Table Security Menu.
2. Type in the table name and press Enter.
The access groups currently assigned to the specified table are
listed on the screen.
A message is displayed if no security has been defined for the
table.
3. If you want a printout of the table security definition, choose
the Print f1 function label.
This sends a copy to the file ADMLIST, which prints to the default
or other specified printer.
4. To see the same information for another table, type in the new
table name over the old one and press Enter.
5. To leave this screen, choose Done f8. This returns you to the
Table Security Menu. From there, you can go to another screen or
exit the utility.
To Show Table Security for a Specific Access Group:.
1. Go to the Show Table Security by Group screen by typing STSG in
the Go to screen field of any menu, or by choosing Show by Group
f4 at the Table Security Menu.
2. Type in the access group name and press Enter.
The tables to which the specified access group is currently
assigned are listed on the screen.
A message is displayed if the access group has not been assigned
to any tables.
3. If you want a printout of the table security definition, choose
the Print f1 function label.
This sends a copy to the file ADMLIST, which prints to the default
or other specified printer.
4. To see the same information for another access group, type in the
new access group name over the old one and press Enter.
5. To leave this screen, choose Done f8. This returns you to the
Table Security Menu. From there, you can go to another screen or
exit the utility.
Listing Public Tables
The List Public Tables screen displays the names and types (IMAGE, view,
and file) of tables that have no table security assigned to them. These
tables can be accessed by all users.
DBA Capabilities.
If you are the primary DBA, you can list all public tables. If you are a
secondary DBA, you can list only public tables that you control.
To List Public Tables:.
1. Go to the List Public Tables screen by typing LPT in the Go to
screen field of any menu, or by choosing List Pub Tables f5 at
the Table Security Menu.
A list of public tables and their types appears on the screen.
A message is displayed if no public tables are configured.
2. If you want a printout of the list of public tables, choose the
Print f1 function label.
This sends a copy to the file ADMLIST, which prints to the default
or other specified printer.
3. To leave this screen, press Done f8. This returns you to the
Table Security Menu. From there, you can go to another screen or
exit the utility.