Fortinet FortiDB - Manual (Page 20)

FortiDB Version 3.2 Privilege Monitor User Guide
18 15-32000-81364-20081219
Oracle System Views System Views
Oracle System Views
System View Name Contents Description Privileges
Involved
SYS.DBA_COL_PRIVS
Column-level
privilege
granting Gives you the ability to monitor
column-level privilege changes. For
example, user SCOTT can grant
SELECT privileges on a column of a
table to a user, without letting that
user SELECT on other columns in
the same table.
SYS.DBA_PROFILES
Resources
(I/O, etc.)
assigned to
users Lists all resources and their limits.
Changes to any profile setting could
have wide-reaching effects.
SYS.DBA_ROLES Database roles Contains information about all
existing roles in the database. An
Oracle role is a grouping of
privileges.
SYS.DBA_ROLE_PRIVS
Roles granted
to users and
other roles Links users with their roles. It also
contains information about which
role has been assigned to other
roles. Change of user’s role means
changes in user’s access privileges.
Role changes should be closely
monitored in order to ensure data
security.
SYS.DBA_SYS_PRIVS
All granted
system
privileges Contains all GRANTed system
privileges to all users or roles.
System privileges are powerful
privileges and should be granted
with great cautions. Monitoring
system-privilege changes should be
mandatory.
SYS.DBA_TAB_PRIVS All granted
schema-
object
privileges Lists all GRANTed privileges on
schema objects. These include
privileges on tables, views,
sequences, procedures, functions
and packages.
SYS.DBA_TS_QUOTAS
Tablespace
quotas
assigned to
users Contains information about
Tablespace quotas assigned to
users. Oracle limits the amount of
space that can be allocated for
storage of a user's objects assigned
quota.
SYS.DBA_USERS
Database
users Contains information about users in
the database. Although this view has
no privilege information, it contains
the users to whom privileges may be
assigned or changed.