At MS SQL 2000, it has two groups of users - u1 & u2 which have the difference permissions to the tables & stored procedures. It setups 2 roles - r1 & r2 to define two sets permissions and grants the permission
(select, exec, ...) to these 2 roles - r1 & r2 in the defined Tables and Stored Procedures.
After upgrade from MS SQL 2000 to MS SQL 2005, it has the schema & role. How to setup the role & schema to meet my requirement?
View Complete Post