Ab Initio Data Warehousing Question:

Describe the Grant/Revoke DDL facility and how it is implemented?

Answer:

Basically,This is a part of D.B.A responsibilities GRANT means permissions for example GRANT CREATE TABLE ,CREATE VIEW AND MANY MORE .

REVOKE means cancel the grant (permissions).So,Grant or Revoke both commands depend upon D.B.A.

Download Ab Initio PDF Read All 39 Ab Initio Questions

Previous Question	Next Question
When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?	What is the difference between rollup and scan?