Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 6 Managing Permissions to Objects : Task B: Identify Table Instances

Task B: Identify Table Instances
If your table is parameterized, you can specify permissions for individual instances or all instances of the table.
Permissions that you grant for a specific parameter value override permissions that you grant at the table level for all instances.
Sample Specify Protection for Table Screen
A screen similar to the one below appears when you select to specify permissions for a parameterized table from the Security Management main menu. In this sample screen, COUNTRY and DISTRICT are parameters belonging to the SERVICEDEPOTS table.

 
 ------------------------------------------------------------------------------
SPECIFY INSTANCE OF TABLE: SERVICEDEPOTS
------------------------------------------------------------------------------
 
Table Parameters: COUNTRY =
DISTRICT =
( ALL DATA: Y )
 
 
 
 
 
 
 
 
 
 
 
 
 
< specify all parameter values or set ALL DATA = Y for whole table >
 
PFKEYS: 1=HELP ENTER=CONTINUE 12=CANCEL

 
Prerequisite Step
To proceed from this screen, decide which of the following tasks you want to perform:
These steps are described in the following sections.
Managing Non-data Access Permissions
The following permissions, which apply to the table itself and not to any specific instances, are not pertinent to data access:
Required Steps
To manage these permissions, complete the following steps:
1.
2.
The screen for non-parameterized tables appears. Refer to Specify Protection Screen for an illustration of this screen.
3.
Data access permissions that you change here apply to the entire table, that is, without regard for its parameterization.
Managing Data Access Permissions to an Entire Table
To manage data access permissions for all instances of a table, do the following steps:
1.
2.
The screen for non-parameterized tables appears. Refer to Specify Protection Screen for an example of this screen.
3.
Data access permissions that you change here apply to the entire table, that is, without regard for its parameterization.
Managing Data Access Permissions to a Specific Table Instance
To manage data access permissions to a specific table instance, do the following steps:
1.
2.
The table instance can be empty of data but you must enter values that are valid for the defined parameters. The screen shown below has a sample entry for each parameter.
3.
Screen to Specify Protection for an Instance

 
 ------------------------------------------------------------------------------
SPECIFY PROTECTION FOR TABLE: SERVICEDEPOTS
------------------------------------------------------------------------------
 
Owned by: HC324F Conrad Powers Classification: 1
Log Accesses: N
Table Parameters: COUNTRY = AUSTRALIA
DISTRICT = NSW2
( ALL DATA: N )
 
 
Name Access Modes Allowed TABLE
(USERID | GROUP) READ INS REPL DEL
---------------- - - - -
 
 
 
 
 
 
 
PFKEYS: 1=HELP 4=OBJECTSETS 9=GROUPS 21=VIEW 6=USERIDS 3=SAVE 12=CANCEL

 
On this screen you can add, change, and delete permissions, but only for the four data access permissions READ, INSERT, REPLACE, and DELETE. These permissions apply only to the instance whose parameter values are shown in the Table Parameters field.
Users or groups accessing a table also need, at least, permission to view the definition of the table. You must give VIEW_DEFN permission separately to the same users. This procedure is explained in Managing Non-data Access Permissions.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved