SQL Server Performance Forum – Threads Archive
grant system object permission to the userI 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,
These procedures are in the master database – you must give them permission here.