November 14, 2023 at 12:51 pm
EXEC sp_readerrorlog 0,1
As shown above, Joe1 has the execute permission on the sp_readerrorlog, however getting the error below:
Msg 27219, Level 16, State 1, Procedure sp_readerrorlog, Line 11 [Batch Start Line 0]
Caller does not have permissions to execute the stored procedure.
November 14, 2023 at 1:33 pm
You need to be a sysadmin to run that procedure
Permissions
Execute permissions for sp_readerrorlog are restricted to members of the sysadmin fixed server role.
November 14, 2023 at 1:39 pm
You need to be a sysadmin to run that procedure
Permissions Execute permissions for sp_readerrorlog are restricted to members of the sysadmin fixed server role.
We have another instance where the user does not have sa role and able to execute this sp. very odd!
November 15, 2023 at 1:45 am
the permission needed to execute the sp is view server state. it worked once i added
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply