Unity Catalog - Lakehouse Federation: Permission to read data from foreign catalogs

Wojciech_BUK
Valued Contributor III

‎01-02-2024 06:54 AM

I have seup connection "SQL-SV-conn" to SQL Server and based on that connection I have created foreign catalog "FC-SQL-SV".

I have granted All permission on CATALOG to developers:

  • Use Catalog
  • Use Schema
  • Select

But they can not query table (e.g. by running SELECT * FROM FC-SQL-SV.my_schema.my_table statement ) and they got this error:

PERMISSION_DENIED: User is not an owner of Connection 'SQL-SV-conn'.
 
Is this a bug ?
Why users need Ownership over CONNCETION, this is not secure at all as I don't want End User to manage my connection.
0 Kudos