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.

Srisakthi's avatar
Srisakthi
Icon for Super User rankSuper User
1 year ago

Can you please paste the error message that you are getting. Also try with the below command. 

Column-level security only applies to queries on a Warehouse or SQL analytics endpoint in Fabric. 

Implement column-level security with the GRANT T-SQL statement. For simplicity of management, assigning permissions to roles is preferred to using individuals. 

GRANT SELECT ([EmployeeName],[EmailId]) on dbo.[DimEmployees] TO "[email protected]"

 

Regards,

Srisakthi

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

    Error message "com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'GRANT'"

    query like 

    GRANT SELECT (id,tenant_id) on dbo.person TO '[email protected]'
     
    select query works fine -- select * from dbo.person