PrepAway - Latest Free Exam Questions & Answers

Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS

Which SQL statement will give a user named USER1 the ability to run an embedded SQL
application named BENEFITS that calls a package named CORPDATA.PKGA?

PrepAway - Latest Free Exam Questions & Answers

A.
GRANT EXECUTE ON APPLICATION benefits TO user1

B.
GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1

C.
GRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1

D.
GRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1

Explanation:


Leave a Reply