Which of the following is NOT an accurate statement about views?
A.
Views are publicly referenced names and no special authority or privilege is needed to use
them.
B.
Views can be used to restrict access to columns in a base table that contain sensitive data
C.
Views can be used to store queries that multiple applications execute on a regular basis in a
database
D.
Views support INSTEAD OF triggers
A is the Answer.
To grant privilege to create a view:
GRANT CREATE VIEW TO STD01;
To grant the DML privileges:
GRANT SELECT,UPDATE,INSERT,DELETE ON STD00.CUSTOMER TO STD01;
0
0
Views do require privilege s to access them
0
0