Since Lakehouse Fed uses only one credential per connection to the foreign database, all queries using the connection will see all the data the credentials has to access to. 

Would anyone know if Lakehouse Fed will support authorization using the credentials of the user running the query?

Thanks!