Privileges panels

These panels are:
  • Application Plan Privileges panel
  • Collection Privileges panel
  • Column Privileges panel
  • Database Privileges panel
  • Distinct Type Privileges panel
  • Function Privileges panel
  • Package Privileges panel
  • Schema Privileges panel
  • Stored Procedure Privileges panel
  • Table Privileges panel
  • Table Space Use Privileges panel

FM/Db2 displays one of these panels if you use the Privileges utility function (3.5) to display privilege details for an object type, or if you specify the P line command against an object displayed in a list of Db2® objects.

Format of privilege display panels

All of the privilege display panels use an ISPF table display of information retrieved from the Db2® catalog. You can scroll through the information in a typical ISPF manner. The information is presented in read-only format.

For each privilege display panel:
  • You can use the Cmd field to enter a line command. The line commands you can enter vary according to the object type. To display a list of valid line commands for the type of objects you are viewing, enter a ? in the Cmd field.
  • Single-character fields show the current status for each privilege that can apply to the object type listed:
    Blank
    The grantee does not have the specified privilege.
    Y
    The grantee has the specified privilege, but cannot grant this privilege to other users.
    G
    The grantee has the specified privilege, and can grant this privilege to other users.
  • At the top of each column of data, immediately below the column name, there are input fields. When the panel is initially displayed, all of these input fields contain an asterisk (*) indicating “all values”. You can use one or more of these input fields to restrict the list of objects listed. For example, by specifying BRA in the entry field below the Grantor column name on the Database Privileges panel shown in Privileges panels, the list of databases is restricted to those where the name of the grantor starts with “BRA”.

Related tasks