Connecting to target databases : Privileges required by the FortiDB database user : Privileges for monitoring data
 
Privileges for monitoring data
To monitor data, the FortiDB user for your target database requires the following privileges:
RDBMS Type
Required Privilege(s)
Oracle
For DB, EXTENDED and XML File Agent collection methods:
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 the TCP/IP Sniffer collection method (to support browsing database to define data policy):
CREATE SESSION
SELECT_CATALOG_ROLE
SELECT on the monitored tables or SELECT ANY TABLE
Microsoft SQL Server
Member of sysadmin
Sybase
For the MDA collection method:
No privilege is required for the MDA table
For the TCP/IP Sniffer collection method (to support browsing database to define data policy):
User who can browse database object
DB2
For the DB2 Agent collection method:
SECADM privilege
For the TCP/IP Sniffer collection method (to support browsing database to define data policy):
User who can browse database object
See also
Data policies
Configuring target database monitoring