SOL-C01 · Question #223
SOL-C01 Question #223: Real Exam Question with Answer & Explanation
The correct answer is D: l, II, III, IV, and V. To share a secure view, you need to create the view, create a share, grant SELECT on the view to the share, grant USAGE on the database to the share, and grant USAGE on the schema containing the view to the share. All steps l, II, III, IV and V are required.
Question
A data provider wants to share a secure view called 'SALES SUMMARY' from the 'RETAIL DATA' database with a consumer. The provider needs to ensure that the consumer can only query the view and cannot see the underlying tables. Which of the following steps are required to accomplish this? l. Create a secure view 'SALES SUMMARY'. II. Create a share. Ill. Grant 'SELECT' privilege on the 'SALES SUMMARY' view to the share. IU Grant 'USAGE privilege on the 'RETAIL DATA' database to the share. V. Grant `USAGE' privilege on the schema containing `SALES SUMMARY' to the share.
Options
- Al, II, and III only
- Bl, II, III, and IV only
- CII, III, and V only
- Dl, II, III, IV, and V
- EII and III only
Explanation
To share a secure view, you need to create the view, create a share, grant SELECT on the view to the share, grant USAGE on the database to the share, and grant USAGE on the schema containing the view to the share. All steps l, II, III, IV and V are required.
Topics
Community Discussion
No community discussion yet for this question.