Ownership of any objects owned by the dropped role is transferred to the role that executes the DROP ROLE command.
https://docs.snowflake.com/en/sql-reference/sql/drop-role#usage-notes
D. The assumed role that dropped the role
In Snowflake, when a role is dropped, the ownership of objects owned by that role (such as tables) is transferred to the role that performed the drop operation. Therefore, the assumed role that dropped the role will now own the two tables.
Correct answer is D
Ownership of any objects owned by the dropped role is transferred to the role that executes the DROP ROLE command.
https://docs.snowflake.com/en/sql-reference/sql/drop-role#usage-notes
D. Dropped roles cannot be recovered; they must be recreated.
Ownership of any objects owned by the dropped role is transferred to the role that executes the DROP ROLE command. To transfer ownership of each of these objects to a different role, use GRANT OWNERSHIP … COPY CURRENT GRANTS.
D is the RIGHT ANSWER
https://docs.snowflake.com/en/sql-reference/sql/drop-role#usage-notes
Ownership of any objects owned by the dropped role is transferred to the role that executes the DROP ROLE command. To transfer ownership of each of these objects to a different role, use GRANT OWNERSHIP … COPY CURRENT GRANTS.
D
Ownership of any objects owned by the dropped role is transferred to the role that executes the DROP ROLE command. To transfer ownership of each of these objects to a different role, use GRANT OWNERSHIP … COPY CURRENT GRANTS.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
uncle_benz
Highly Voted 2 years, 4 months agoPrasantSadangi
Most Recent 5 days, 7 hours agorocky_vits1
3 months agoMallikharjuna452
8 months, 2 weeks agoPrashantGupta1616
9 months, 4 weeks ago_yyukta
1 year, 1 month agoBobFar
1 year, 5 months agoMarge23
1 year, 7 months agomagnasiun1
1 year, 9 months agoMayuri917233
1 year, 10 months agoJosa2
2 years, 1 month agoAndroJS
2 years, 2 months agoTapasgup007
2 years, 3 months agoseaun
2 years, 5 months agogreenlever
2 years, 5 months agogreenlever
2 years, 5 months agoTapsinha
3 years, 2 months ago