Locking Down SQL*Plus Security : Is your
data at risk? Users with valid database username/password combos can log into a
database from SQL*Plus and view or edit critical data not accessible from an
application itself. The question is, how do you prevent users from accessing
data via SQL*Plus? Learn how to insert restrictions in the PRODUCT_USER_PROFILE
(PUP) table, owned by the SYSTEM user. DDL Event Security in Oracle Database :
Secure your Oracle database against structural or Data Definition Language
(DDL) changes. Oracle Label Security, Part 4: Conclusion :
Oracle Label Security (OLS) offers a powerful implementation of row-based
security that is perfect for restricting user access to specific data,
especially in a data mart or data warehousing environment. This concluding
article wraps up this series with a discussion of some advanced OLS features as
well as mechanisms for maintaining an existing OLS security policy. Oracle Label Security, Part 3: Administration :
Oracle Label Security (OLS) offers a powerful implementation of row-based
security that is perfect for restricting user access to specific data,
especially in a data mart or data warehousing environment. Previous articles
presented a brief overview of how these features work, and how these features can
be implemented in any Oracle database. This article discusses how Oracle Label
Security policies can be administered when data or users change. Oracle Label Security, Part 2: Implementation :
Oracle Label Security (OLS) offers a powerful implementation of row-based
security that is perfect for restricting user access to specific data,
especially in a data mart or data warehousing environment. A previous article
presented a brief overview of how these features work; this article presents
how a reasonably skilled Oracle DBA can configure a database for OLS, install
an OLS security policy, implement security for users, and impose row-level
security for data. Oracle Label Security, Part 1: Overview :
Oracle Label Security (OLS) is a relatively new feature of Oracle 9i. It offers
a powerful implementation of row-based security that's perfect for restricting
user access to specific data, especially in a data mart or data warehousing
environment. This article presents a high-level view of this new set of
features in preparation for implementation by any reasonably skilled Oracle
DBA. Definer and Invoker Rights for stored routines in Oracle
: Learn how to share procedures between users without sharing tables.
