Im facing some troubles setting up a SQL user for my system. A need to create an SQL User, whom only have read access from the view A, read/write to table B and should not be able to see the remaining tables. I have spent some time on this trying to figure
out how the permission system actually works, but I havent found the configuration that actually works.
What I have done is created a user without any schemas and roles and under securables granted access to read in A and read/write in B. When I use this configuration I cannot access any tables. If I give the user db_datareader/db_datawriter I can perform
all actions on all tables.
Can somebody guide me through how to create a user with these limitations? I'm really stuck.
Thanks in advance,
View Complete Post