Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • Reply To: 'sa' impersonation

    are you sure ...?

    if I understand ...to run the procedure with EXECUTE AS 'sa' I have to give a user a grant to impersonate 'sa'.

    Am I granting him the priviledge...

    October 2, 2020 at 3:24 pm

    #3792531

  • Reply To: 'sa' impersonation

    so if I understand you correctly, if I give them the permission to execute the procedure I am not giving them any god given rights so they can execute something...

    October 1, 2020 at 4:46 am

    #3792159

  • Reply To: 'sa' impersonation

    Would WITH EXECUTE AS OWNER make any difference  ???

    or

    Can I just add this stored procedure to the list of securables their  role can execute ?

    Would not then  this procedure be...

    • This reply was modified 4 years, 1 month ago by  SZ.
    • This reply was modified 4 years, 1 month ago by  SZ.

    September 30, 2020 at 7:00 pm

    #3792069

Viewing 3 posts - 1 through 3 (of 3 total)