Hi
I have 2 sql Login accounts and for these 2 accounts
How to find out the
1. Server Roles (bulkadmin, dbcreator,diskadmin etc.,).????
2. user mapped databases.????
3. database roles.????
4. database role and user database is 1-to-1 mapping or not.????
Ex: TestDB ---> mapped to ---> db_datareader
SampleDB ---> mapped to ---> db_ddladmin
5. Deny access on Tables.????
Please advice me any script or any solution.
🙂 Thanks