Permission verification

• mtz676

  SSCrazy Eights

  Points: 9217

  More actions

  December 11, 2008 at 4:58 pm

  #132976

  Hi If some user XYZ has asked me permissions to give him access to a AAA database on some PQR server and after doing so how do I verify If I have successfully given him the required permission without asking him if I he able to login into the database ? Any ideas please . The issue here I do not want to get back to the customer to verify , I would like to do it myself !

  thanks!

• jminette

  Ten Centuries

  Points: 1352

  More actions

  December 11, 2008 at 5:45 pm

  #911403

  You could use the "EXECUTE AS" statement. It will let you change the execution context of the session.

  EXECUTE AS USER = 'testUser'

  SELECT * FROM dbo.TestTable