This API enables non-admin users to view attributes for certain groups in Query-Report Builder.

Within Query-Report Builder, admin users can see all attributes while non-admin users can view only query attributes, except attributes that are designated as admin only (such as IDs). Use enable_special_attributes to allow non-admin users to view all of the attributes within a specified attributesGroup.

Note: When an attribute group is enabled, all of the attributes within that group are available.
Note: With the following exception, you do not need to restart the GUI for changes to take effect. If a report with the attributes of group F5 is added to My New Reports, a non-admin user does not have privileges to view the report until the GUI is restarted.

This API is available in Guardium V9.5 and later.

GuardAPI syntax

enable_special_attributes parameter=value


Parameter Value type Description
attributesGroup String Required. Valid values:
  • data set
  • ims
  • hive
  • apex
  • mapreduce
  • bi
  • ims/data set
  • f5
  • db2 i


The following example enables Hive attributes for all non-admin users:

grdapi enable_special_attributes attributesGroup=hive
Sample output
> grdapi enable_special_attributes attributesGroup=hive
Following Attributes have been Enabled: Hive Parsed SQL, Hive User, Hive Command, Hive Database, 
Hive Table Name, Hive Error