Fortinet FortiDB User Manual download pdf (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.

1 2 ... 15 16 17 18 19 20 21 22 23 24 25 ... 51 52

Comments to this Manuals

No comments