To grant ALTER on a specific schema for User1, which object should appear after the ON clause?

• A. Schema::SchemaA
• B. Database::SchemaA
• C. SchemaA
• D. Schema::SchemaB

Answer: (A)

When you grant privileges, the ON clause identifies the exact object you’re targeting. For a schema, you must reference it with its object type and name in a fully qualified form. That means using the type “Schema” followed by double colon and the schema’s name, e.g., Schema::SchemaA. This clearly specifies the target as the schema named SchemaA.

Using a plain name like SchemaA lacks the required type context, which the syntax expects for unambiguous resolution. Database::SchemaA would point to a database object rather than the specific schema, and Schema::SchemaB would refer to a different schema. So the correct target after ON to grant ALTER on that particular schema is Schema::SchemaA.