Privileges for Monitoring Metadata

To monitor metadata, FortiDB target database users need the following privileges:
RDBMS Type Required Privilege(s)
Oracle
  • CREATE SESSION
  • SELECT_CATALOG_ROLE
for use with auditing:
  • CREATE SESSION
  • AUDIT SYSTEM
  • SELECT_CATALOG_ROLE
MSSQL

For Collection Method 'SQL Trace'

SELECT on:

  • information_schema.columns
  • sysindexes
  • sysobjects
  • information_schema.routines
  • sys.objects obj
  • sys.sql_modules
  • information_schema.views

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