Connecting to target databases : Privileges required by the FortiDB database user : Privileges for monitoring metadata
 
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
Microsoft SQL Server
For the SQL Trace collection method:
SELECT on:
information_schema.columns
sysindexes
sysobjects
information_schema.routines
sys.objects obj
sys.sql_modules
information_schema.views
For the TCP/IP Sniffer and Net Agent collection methods:
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
See also
Metadata policies
Configuring target database monitoring