Forum Discussion

yongshao's avatar
yongshao
Icon for Helper III rankHelper III
1 year ago
Solved

Column level security with SQL analytics endpoint

We have a Fabric lakehouse to host data in delta tables, we want to add column level security to its SQL endpoint. not working when executing grant query in its SQL query window "GRANT SELECT ON ......
data engineering
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi yongshao 
    Sorry for the late response.
    After Granting the access to the columns ask the user to query which was not granted the access for that column.



    If the above information helps you, please give us a Kudos and marked the Accept as a solution.
    Best Regards,
    Community Support Team _ C Srikanth.

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
1 year ago

Hi yongshao 
Sorry for the late response.
After Granting the access to the columns ask the user to query which was not granted the access for that column.



If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.