Fabric platform
NewManage Permissions nomenclature: Read only grants CONNECT, not READ permissions
Todd Chittenden on 21 Jan 2025 23:08:06
Based on this link () the default permissions granted on a Warehouse, if no other permissions are selected, is "Read". But "Read" permissions does not grant the user the ability to READ from the Warehouse. It grants the user the ability to CONNECT. From the article is this statement:
If no additional permissions are selected - The shared recipient by default receives "Read" permission, which only allows the recipient to connect to the SQL analytics endpoint, the equivalent of CONNECT permissions in SQL Server. The shared recipient won't be able to query any table or view or execute any function or stored procedure unless they're provided access to objects within the Warehouse using T-SQL GRANT statement.
Please make the words DO what the words MEAN, and vice versa. If the permission is ONLY granting CONNECT permissions, call it CONNCT.
This will make managing permission easier to understand.