79093971

Date: 2024-10-16 12:17:50
Score: 1.5
Natty:
Report link

Please note, every grant is authorized by a particular grantor, which means that there can be multiple grants of the same permission to the same role, each with a different grantor.

To revoke the privilege, make sure the revoke command is executed by either the grantor of the privilege grant or by a role that inherits the grantor role as part of its role hierarchy.

Try revoking privileges on this warehouse that are granted to another role; and then also change the OWNERSHIP of the table, which was also owned by the other role.

There is a supporting KB article for your reference: https://community.snowflake.com/s/article/Revoke-command-execution-succeeds-but-the-privilege-is-still-granted-to-the-role?

Option 2) Try revoking some privileges on this warehouse in case granted to another role; and then also change the OWNERSHIP of the warehouse if owned by any other role.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Khathibur Rehman