Answer-first summary for fast verification
Answer: GRANT ALTER ON SCHEMA::schemaA TO User1;
To truncate tables in a specific schema, the user needs ALTER permission on that schema. Therefore, the correct T-SQL statement is 'GRANT ALTER ON SCHEMA::schemaA TO User1;'. This grants User1 the required ALTER permissions on schemaA, allowing them to truncate tables within this schema without affecting other schemas.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are managing a Fabric tenant which includes a data warehouse named Warehouse1. Within Warehouse1, there are three distinct schemas: schemaA, schemaB, and schemaC. Your objective is to ensure that a user, referred to as User1, has the permission to truncate tables within schemaA exclusively. How would you complete the T-SQL statement to achieve this? NOTE: Each correct selection is worth one point.
A
GRANT ALTER ON SCHEMA::schemaA TO User1;
B
GRANT EXECUTE ON SCHEMA::schemaA TO User1;
C
GRANT ALTER ON OBJECT::schemaA TO User1;
D
GRANT EXECUTE ON OBJECT::schemaA TO User1;
No comments yet.