Name of Schema : wages
Schema Exists in 3 DBs
Current Access:- Developers and analysts with membership in multiple groups have access.
1) 5 users(developers/analysts) assigned to that project can only access objects under Wages schema.
2) All other users in the database should not be able to access that schema objects.
3) If we perform DENY on Groups to that SCHEMA unfortunately the above 5 users who are assigned to that projects are members of different group which currently has access. So i need to remove them before denying access.
4) I currently created two roles one for access and one for Deny.
I am happy to provide additional details if required.
MSSQL replication question ,SQL REPLICATION :- I am setting up the replication from sql 2000 to sql 2008r2 on prem to cloud , snpshot is generating with out any issue and but some tables are failing applying on the subscriber , error message ,