Hi,
I would like to be crystal clear about how to confirm if any user has access and will need your advise and help.
Example : So Let us say if DomainName\User ( e.g. Adventure\UserDemo) has access to Specific user database says School db?
Upon checking I see the userdemo is present under School Db- security - user roles - and Userdemo
So when I check the properties of that Userdemo it has all unchecked under Owned schema and MEMBERSHIP has data reader DDLadmin checked. Does this mean the user has access and full control of the school db? Do we need to check the Db_owner under Owned schema window?
Please share any best practise or sampe login checking script.