IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Suppose that we have a table of 10 rows in which only the first 5 rows are used / required by the application team. As a DBA, we can decide …
Read More »Tag Archives: oracle advanced security
Database Security and User Profile Parameters and How to Check Password Policy in Oracle 12c
Hi, I will explain you about Oracle Database Security , Database and Profile Security Parameters in this article.
Read More »Defining VPD (Virtual Private Database) Policy Groups -3
When a VPD is defined on a table, all VPD definitions are passed to AND. This means that all VPD definitions apply. Before this article you should look the previously …
Read More »Oracle Virtual Private Database (VPD) -2
DBMS_RLS Package We use DBMS_RLS to create, modify, or delete security policies with VPD. The DBMS_RLS.ADD_POLICY procedure allows us to create a VPD security policy. The definition of parameters used in …
Read More »Oracle Virtual Private Database (VPD) – 1
Virtual Private Database allows us to define constraints on tables and views based on row and column security policies. It should not be considered as a separate database because of the …
Read More »Oracle Application Context – 1
Application Context are memory fields that contain information about the sessions of users connected to the database. According to the information in the application context, the logged-on user is denied or …
Read More »