Fortinet FortiDB - Manual (Page 24)

FortiDB Version 3.2 Privilege Monitor User Guide
22 15-32000-81364-20081219
SQL Server System Views System Views
SQL Server System Views
Sybase Server System Views
Changing System Views Settings
Privilege Monitor allows you to change System Views settings.
System View Name Contents Description Privileges Involved
Column Privileges syscolumns Column-level privileges
Members sysmembers Role- and group-
membership
assignments
Object Privileges sysprotects Column- and table-and
other object-level
privileges
Roles
1
/Groups
1. When a database connection is established with the Audit radio button checked, alerts will not be generated when
Application roles are created or dropped. (i.e. when the sp_addapprole and sp_dropapprole stored procedures are used.)
sysobjects All objects that are
accessible
by the current user
Server Roles sp_helpservrolememb
er (a view) Default server roles
assigned to users.
Users sysusers Lists valid database
users and the groups to
which they belong
System View Name Contents Description Privileges Involved
Column Privileges syscolumns Column-level privileges
Roles/Groups sysobjects All objects that are
accessible
by the current user
Members sysmembers Role- and group-
membership
assignments
Object Privileges sysprotects Column- and table-and
other object-level
privileges
Server Roles sp_helpservrolememb
er (a view) Default server roles
assigned to users.
Users sysusers Lists valid database
users and the groups to
which they belong
Note: Sybase User Policies will generate alerts only for creating and deleting, not
modifying, users.