PrepAway - Latest Free Exam Questions & Answers

Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

Which SQL statement will allow user USER1 to create a view on a table named
EMPLOYEE?

PrepAway - Latest Free Exam Questions & Answers

A.
GRANT CREATETAB ON DATABASE TO user1

B.
GRANT SELECT ON TABLE employee TO user1

C.
GRANT CREATEVIEW ON DATABASE TO user1

D.
GRANT REFERENCES ON TABLE employee TO user1


Leave a Reply