Viewing 2 posts - 1 through 2 (of 2 total)
I understand now. It is recommended to use sys.dm_tran_locks, instead of sys.syslockinfo.
However, I tried granting rights to sys.dm_tran_locks and I still received the same error message.
Thanks!
March 23, 2006 at 4:42 pm
#628489
I created an application role named testit.
Then I executed:
Grant select on sys.syslockinfo to testit
However, I still receive the message
"The user does not have permission to perform this action", if I...
March 22, 2006 at 10:19 am
#628165