Fortinet black logo

Handbook (HTML)

Privileges for monitoring metadata

Copy Link
Copy Doc ID 73ac471a-9afd-11ea-8862-00505692583a:48663

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

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