https://community.databricks.com/t5/data-engineering/grant-permission-on-catalog-but-revoke-from-schema-for-the-same/m-p/81017#M36197 <P>This unfortunately is not possible due to the hierarchical mechanism in UC, you will need to grant permissions to the specific schemas directly and not by providing a major permission at the catalog level</P> Mon, 29 Jul 2024 20:44:28 GMT Walter_C 2024-07-29T20:44:28Z https://community.databricks.com/t5/data-engineering/grant-permission-on-catalog-but-revoke-from-schema-for-the-same/m-p/80743#M36145 <P>I have a catalog ( in unity catalog) containing multiple schemas.&nbsp; I need an AD group to have select permission on all the schemas so at catalog level I granted Select to AD grp.&nbsp; Then, I need to revoke permission on one particular schema in this catalog from the AD group ( actually a user in the AD grp).&nbsp; &nbsp;I tried revoking schema-level access from the AD group and also from the user, but the group &amp; user are still able to access.&nbsp; Is there an issue?&nbsp; &nbsp;</P><P>&nbsp;</P> Fri, 26 Jul 2024 16:01:09 GMT https://community.databricks.com/t5/data-engineering/grant-permission-on-catalog-but-revoke-from-schema-for-the-same/m-p/80743#M36145 prasadvaze 2024-07-26T16:01:09Z https://community.databricks.com/t5/data-engineering/grant-permission-on-catalog-but-revoke-from-schema-for-the-same/m-p/81017#M36197 <P>This unfortunately is not possible due to the hierarchical mechanism in UC, you will need to grant permissions to the specific schemas directly and not by providing a major permission at the catalog level</P> Mon, 29 Jul 2024 20:44:28 GMT https://community.databricks.com/t5/data-engineering/grant-permission-on-catalog-but-revoke-from-schema-for-the-same/m-p/81017#M36197 Walter_C 2024-07-29T20:44:28Z