Ab Initio Data Warehousing Question:

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.


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?