SOL-C01 Question #81: Real Exam Question with Answer & Explanation

Question

You have created a new database named 'DEV DB' and want to grant the "SELECT' privilege on all tables within this database to the 'ANALYST' role. You want to ensure that any new tables created in 'DEV DB' in the future automatically grant 'SELECT' to the 'ANALYST' role. Which of the following approaches achieves this?

Options

• AGRANT SELECT ON ALL TABLES IN DATABASE DEV DB TO ROLE ANALYST;
• BGRANT FUTURE GRANTS SELECT ON DATABASE DEV DB TO ROLE ANALYST;
• CGRANT SELECT ON FUTURE TABLES IN DATABASE DEV DB TO ROLE ANALYST;
• DGRANT SELECT ON DATABASE DEV DB TO ROLE ANALYST; ALTER DATABASE DEV DB
• EALTER DATABASE DEV DB SET GRANTED PRIVILEGES = 'SELECT' TO ROLE ANALYST;

Explanation

The `GRANT ON FIJTIJRE TABLES IN DATABASE TO ROLE syntax is specifically designed to grant privileges on tables created in the future. Option A only grants the privilege on existing tables. Option B is incorrect because the privilege order is wrong, it should be GRANT ON FUTURE TABLES IN DATABASE. Options D and E use incorrect syntax and do not achieve the

No community discussion yet for this question.