Grant privileges panels

These panels are:
  • Grant Application Plan Privileges panel
  • Grant Buffer Pool Privileges panel
  • Grant Collection Privileges panel
  • Grant Column Privileges panel
  • Grant Database Privileges panel
  • Grant Distinct Type Privileges panel
  • Grant Function Privileges panel
  • Grant Package Privileges panel
  • Grant Schema Privileges panel
  • Grant Sequence Privileges panel
  • Grant Storage Group Privileges panel
  • Grant Stored Procedure Privileges panel
  • Grant System Privileges panel
  • Grant Table Privileges panel
  • Grant Table Space Use Privileges panel

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

Format of grant privilege panels

Each grant privilege panel shows:
  • The available privileges for the object type, with a corresponding single-character entry field in which you can specify one of the following values:
    Y
    Grants the specified privilege to the grantee, but does not permit the grantee to grant this privilege to other users.
    G
    Grants the specified privilege to the grantee, and permits the grantee to grant this privilege to other users.

    A blank in the field indicates that the grantee does not have the specified privilege.

    Note: To change an existing privilege, you must first revoke the existing privilege before granting the new privilege (if applicable) as described in this section.
  • A field (for some types of privilege there are two fields), that you use to specify the name of the object for which the privilege is to be granted.
  • A To field. Use this to specify the SQLID of the user to whom the privilege is to be granted.

Related tasks