SnowPro Advanced: Architect — Question 120

A user creates table T1 in schema S1. The user immediately realizes that they left off a column in the table. Using the same role, the user runs this command:

ALTER TABLE s1.t1 add column c5 number;

The following error message is received:

Insufficient privileges to operate on table 'T1'.

What could cause this to occur?

Answer options

• A. The user does not have the CREATE TABLE privilege on the schema S1.
• B. The user does not have the ALTER TABLE privilege on the schema S1.
• C. The schema S1 has a FUTURE OWNERSHIP grant on a higher-level role.
• D. The user needs to include the database in the reference for T1 in the ALTER TABLE command.

Correct answer: C

Explanation

The correct answer is C because the FUTURE OWNERSHIP grant on a higher-level role could restrict the user's ability to alter the table. Options A and B are incorrect as the user created the table, indicating they have the necessary permissions. Option D is not applicable since the user is already operating within the correct schema context.