Security

Point 1. Check & verify on QA & Prod entries should be available in PublisherDBModule (Authdb) for created all DB's Users.

Point 2. Check & verify on QA & Prod created users must be successfully login using dbuser & Dbpassword from PublisherDBModule.

Goto->Database->Click on Connect->Enter Server Name, User & password as per PublisherDBModule and click on Options enter Database & then Connect.

Point 3. If login failed then check entries in PublisherDB & PublisherDBModule if found mismatch then follow below steps (3.i & 3.ii) on QA & Prod.

 3 (i). In Authdb2:Re-Set Password in PublisherDBModule table.

 3 (ii). In Database: Recreate user, using below steps. 

Point 4. Roles must be moved to another database for tables/functions only not for users.

Point 5. All Roles membership file should be present in Users file in data project not in Role file.