How do I grant a non sysdba user who has bulkadmin and dbcreator rights to schedule jobs on databases they've created?
The user is a developer and we dont want to give him sysdba rights.
try if this works
use the Execute AS command which is used to impersonate any user
havent done much of a research on that one but u can easily get stuff on BOL
|||http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?topicid=12&faqid=137 for your information to accomplish the task.
No comments:
Post a Comment