I have a sql login that i want to restrict to one schema, how can i do that?
for example user1
I want user1 to only see marketing.customers. I have many more under the same schema. I want the user to me able to select from all the tables that exists for this schema. Is there a script for this?