Ab Initio Data Warehousing Question:

Download Job Interview Questions and Answers PDF

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

Ab Initio Interview Question
Ab Initio Interview Question

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 Interview Questions And Answers PDF

Previous QuestionNext 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?