Forum Discussion

alfBI's avatar
alfBI
Icon for Responsive Resident rankResponsive Resident
1 year ago
Solved

Granular access to specific objects within the Warehouse does not work using Power Desktop

Hi,   We have a Warehouse where we want to restrict access to certain tables when users connect to its SQL End Point. We followed the steps described here   https://learn.microsoft.com/en-us/fabr...
Warehouse
  • NandanHegde's avatar
    NandanHegde
    1 year ago

    Please follow the below steps  :

    My source Warehouse :

     

     

    Share the warehoue with the user to grant him/her connect access by disabling all features:

     

    Then login to Warehouse and execute the below queries :

    GRANT SELECT ON <<TableNme>> TO [<<[email protected]>>];
     
    Post that only specific objects are visible:

     

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

Please follow the below steps  :

My source Warehouse :

 

 

Share the warehoue with the user to grant him/her connect access by disabling all features:

 

Then login to Warehouse and execute the below queries :

GRANT SELECT ON <<TableNme>> TO [<<[email protected]>>];
 
Post that only specific objects are visible: