Fine Grained Access Control
In this section, we will discuss about Fine Grained Access Control.
Overview
The authoritative rules (as referred to above) enable the security at a table row or a column. This feature limits the access to the secured data only for the users who are authorized for it. The feature is known as Fine Grained Access Control (FGAC). The FGAC security feature imposes row-level and column-level security so that only privileged users can see them. The feature creates a private window of a table for the currently logged in user who can view only the data for which he is authorized.
Prior to FGAC, it used to be a cumbersome activity to decide the data authorization barriers and segregate the schema or the data, as required. Maintenance of multiple users and their multiple schemas used to be a DBA's overhead.
In a multiuser database environment, users are required to access the information authorized for them. One way could be that admin holds the schema and all database objects...
