To permit a user to truncate tables only within schemaA, which X and Y tokens should be used in the GRANT statement?

To permit a user to truncate tables only within schemaA, which X and Y tokens should be used in the GRANT statement?

• A. ALTER ON SCHEMA::schemaA
• B. CONNECT ON SCHEMA::schemaA
• C. EXECUTE ON SCHEMA::schemaA
• D. ALTER ON DATABASE::schemaA

Answer: (A)

Truncating a table requires ALTER permission on the target table. Granting ALTER at the schema level gives that necessary capability for all tables inside that schema, without opening up rights to objects outside the schema. So using ALTER on SCHEMA::schemaA lets the user truncate any table in schemaA, while still keeping other schemas and broader database permissions off-limits. Other options don’t fit the goal: CONNECT on a schema isn’t a valid or relevant permission for truncation; EXECUTE on a schema is about running procedures or functions; ALTER on the database is too broad, affecting the entire database rather than just the specific schema.

Truncating a table requires ALTER permission on the target table. Granting ALTER at the schema level gives that necessary capability for all tables inside that schema, without opening up rights to objects outside the schema. So using ALTER on SCHEMA::schemaA lets the user truncate any table in schemaA, while still keeping other schemas and broader database permissions off-limits.

Other options don’t fit the goal: CONNECT on a schema isn’t a valid or relevant permission for truncation; EXECUTE on a schema is about running procedures or functions; ALTER on the database is too broad, affecting the entire database rather than just the specific schema.