TABLE A BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001 NULL NULL 10005899 en-US 1561001 NULL NULL 10005899 nl-NL 1561001 35023080 NULL 10005899 en-US 1561001 35023080 35023080 10005899 en-US TABLE B BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001...

Hi, Welcome to the forum!! Here are some link you can refer, this will clear your doubts understand what is Application Role http://msdn2.microsoft.com/en-us/library/ms190998.aspx and http://www.databasejournal.com/features/mssql/article.php/3363521 pros and cons of Application Role http://www.sqlservercentral...

Hi, Here are some referrence article for Role, http://www.databasejournal.com/features/mssql/article.php/1441261 -- Understanding Role(s) http://msdn2.microsoft.com/en-us/library/ms187936.aspx -- How to create Role(s) http://www.odetocode.com/Articles/215.aspx -- Role based security in reporting server