Learn to dream database, look more like Oracle user management system, the first dream is regardless of the user login (user) and (login), or create a user, you can use the user login, and specific access which objects directly to the user empowerment,


In contrast, SQL Server, the first thing to create a login (login), the login may have database connection instance level authority, database object privileges, but if you need to access a database, you need to create a user in database and the corresponding to this login, separate to this user empowerment,

Let me do a dream of database permissions on the column experiment, first to the TESTER is the user a permission, in PERSON the ADDRESS on the library table columns ADDRESS2 read-only privileges,

Then I come to look at the fields,

Then let me check the other fields,

And then I write conditions inside the other fields,

Here again the way, to give a user a column in the SQL Server query access to the first form is the premise of empowerment, can be seen in the query manager,

Above is a little experience to learn, later will also study carefully, thank you for your reading,