We are in the process of an application rewrite from the DB level up. Our current DB is SQL2000 and we have just purchased SQL2008
R2. I've read through various articles regarding Login's, Users and understand the difference. I am confused about Schema's and their benefits.
I have created two Login accounts as WindowsLogin1 and WebLogin1.
I have also created a database called MyDB with two tables T1 and T2.
I’ve also created a WindowsUser1 and WebUser1 user accounts.
So far so go, now for some questions:
If I want WindowsUser1 to have Select, Delete, Insert, Update and Execute permissions on both T1 and T2 tables, should this be done with a role or schema (and how).
If I want WebUser1 to only have Select, Delete, Insert, Update and Execute permissions on the T2 table, should this be done with a role or schema (and how).
If we are using Schema’s for questions #1 and #2, do we construct two distinct schemas?
What about stored procedures?
Should they be added as part of the schema (i.e. Server.MyDB.Schema1.myStoredProc1?
Should the tables T1 and T2 be contained by the schema?
Does adding schema
View Complete Post