 |
|
Oracle Tips by Burleson |
Chapter 5 Oracle Virtual Private Database
PLS-00201:
identifier 'DBMS_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
He does not have privileges to execute
dbms_session directly, so there is no way he can set it up.
The current setting of this attribute can be
seen by:
select
sys_context('USERENV','CLIENT_IDENTIFIER')
from dual
/
The Introduction of
VPD
So far, we have talked about the security for
object accesses and other system privileges that are decided through
roles. However, another cornerstone of our security policy is the
Virtual Private Database (VPD), and that has not been taken into
account in this setup. The present definition of policy functions
will not be able to cater to the VPD requirements. In the present
policy function, we determine the list of providers this user is
allowed to see using the following query.
The above text is
an excerpt from:
Oracle Privacy Security Auditing
The
Final Word on Oracle Security
This is the only authoritative
book on Oracle Security, Oracle Privacy, and Oracle Auditing written
by two of the world’s leading Oracle Security experts.
This indispensable book is only $39.95 and has an
immediate download of working security scripts:
http://rampant-books.com/book_2003_2_audit.htm
|
