User access

• sizal0234

  SSCrazy

  Points: 2272

  More actions

  January 17, 2020 at 8:53 pm

  #3716420

  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.

   

   

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  January 18, 2020 at 9:10 pm

  #3716562

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.