2. Fundamentals of Using Querying and Reporting Tools : Access to Database Tables
 
Share this page                  
Access to Database Tables
You can access a table, view, or synonym in the forms-based tools only if one of the following is true:
You are the object's owner
You have been granted the proper permission to access the object
Access to a view automatically provides access to the columns in the underlying table that are defined in the view. The DBA or owner of a table can grant different types of access to a table, called privileges. These privileges are:
Select
Insert
Delete
Update
Reference