Schema permission on a specific user

Question

Schema permission on a specific user

Navigation

#1 by (1 votes)
#2 by (1 votes)

1

I created a default database and created some schemas within this database. I created users for each schema, now I want to give full permission to each user in their schema only, how should I do?

sql-server sql-server-2014

asked by anonymous 05.10.2015 / 19:26

2 answers

1

Properties of your SCHEMA > On the left tab, click on permissions > click Search (to search for the user) > just below are the permissions of the user on Schema

07.10.2015 / 11:56

Relationship table query N: N How do I access the pointer of a struct within the pointer of another struct?

score 1 · Accepted Answer

In a simple way it will look like this:

GRANT TAKE OWNERSHIP ON SCHEMA::Person TO USER_1

You need to see what level of permissions you want to give the user in question, you can remove all doubts at this URL MSDN