Post reply

Select * from master..sysprocesses

  • April 30, 2008 at 3:11 am

    #185898

    Hello,

    I need to do a Select * from master..sysprocesses in a stored procedure, now I want to protect te source of the streds so I connect with a user with only execute rights on that database, now if I execute that script I've got an error that i've not enough rights on the mssqlsystemresource database.

    If I give the user the sysadmin rights there's no problem and the select is also successful. But the user can now modify the stored procedures.

    How can I fix this? I'll not give the users sysadmin rights but they must be able to execute the select on master..sysprocesses.

    Thanks

  • April 30, 2008 at 4:40 am

    #808911

    You can cerate the stored procedure and grant execute permission to the perticular user.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

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

You must be logged in to reply to this topic. Login to reply