Our Remote DBA Clients

PRIVILEGE

DESCRIPTION

INSERT

Allows the grantee to insert records into the object. Since inserts can be specific to only some objects, they can be granted on tables, views and materialized views.

ON COMMIT REFRESH

In real time data warehouse or OLTP environments where the materialized view (a.k.a. snapshot) has to be refreshed as soon as the source table row is updated, the MV must be created with the ON COMMIT REFRESH clause. This privilege allows the grantee to create an MV in that manner.

QUERY REWRITE

In data warehouse environments, the MVs could be pre-created as the queries the users might execute, and when users actually run those queries, Oracle merely retrieves the data from the pre-created MVs, increasing performance. This process is called query rewriting. This privilege allows the grantee's session to rewrite the query to select from the MV.