Privileges for Monitoring Privilege

To monitor privileges, the FortiDB user for your target database need the following privileges:
RDBMS Type Required Privilege(s)
Oracle
  • CREATE SESSION
  • SELECT_CATALOG_ROLE
  • DELETE_CATALOG_ROLE
  • AUDIT SYSTEM
MSSQL

For Collection Method 'SQL Trace'

SELECT on:

  • sys.columns
  • sys.database_role_members
  • sys.database_permissions
  • sysobjects
  • sys.database_principals
  • sys.sql_logins

EXECUTE on:

  • sp_helpsrvrolemember

For Collection Method 'TCP/IP Sniffer' and 'Net Agent'

  • No privilege is required
Sybase No privilege is required for the MDA table, or TCP/IP Sniffer
DB2 UDB

SECADM privilege for DB2 Agent

No privilege is required for TCP/IP Sniffer

Related concepts
Privileges of DB User for FortiDB



FortiDB 5.0.0 Handbook
1st Edition , July 11 2013
© Copyright 2013 Fortinet Inc. All rights reserved.
Latest documentation: http://docs.fortinet.com/fdb.html