I need a help on SQL Script and not a manual procedure (as i know on it).to do below scenario
1) A login 'testuser' exists on a server which as db_dataread,db_datawrite and db_owner permissions and have around 4 Users tagged to it under 3 different Databases
Datasae1 with user testuser tagged to login testuser
Datasae2 with user testuser tagged to login testuser
Datasae3 with user testuser tagged to login testuser
So now I need a script to
1) Change the permission on login 'testuser' to just db_datareader, db_datawriter, db_ddladmin and execute.
2) After change in permissions on login 'testuser' i hope corresponding users tagged to it on different DBs will also get updated , pls confirm?
Thanks in advance!!!:-)