I have a sql server 2012 instance set up as a filestore on a networked server. I need all users on computers on the same network to be able to browse the file system representing the file table. However all user can see the server, and top level directory but do no have permission to access/ open it.
What permissions should I be looking at to enable access.
use myDatabase
go
grant view definition to [user]