Privileges for Monitoring Data

For Collection Method 'DB, EXTENDED' and 'XML File Agent'

• CREATE SESSION
• SELECT_CATALOG_ROLE
• DELETE_CATALOG_ROLE
• AUDIT ANY
• AUDIT SYSTEM
• SELECT SYS.AUD$
• SELECT on the monitored tables or SELECT ANY TABLE

For Collection Method 'TCP/IP Sniffer', 'SGA Agent', 'Net Agent' (Privileges need for browsing database to define data policy)

• CREATE SESSION
• SELECT_CATALOG_ROLE
• SELECT on the monitored tables or SELECT ANY TABLE

For MDA

• No privilege is required for the MDA table

For Collection Method 'TCP/IP Sniffer' (Privileges need for browsing database to define data policy)

• User who can browse database object

For DB2 Agent

• SECADM privilege

For Collection Method 'TCP/IP Sniffer' (Privileges need for browsing database to define data policy)

• User who can browse database object