grant system object permission to the user | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

grant system object permission to the user

I create the new database and make user as dbo, but the user could not execute store procedure such as sp_lock. Would you please tell me how to grant permission to this user on his database? Thanks,
– Kathy
These procedures are in the master database – you must give them permission here.
]]>