Advertisement
Guest User

Untitled

a guest
Mar 27th, 2015
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. USE abc
  2.  
  3. Create ROLE db_exec
  4. go
  5.  
  6. GRANT EXECUTE TO db_exec
  7. go
  8.  
  9. EXEC sp_addrolemember 'db_exec', 'abc_user'
  10. go
  11.  
  12. use master
  13. go
  14.  
  15. grant exec on sp_OACreate to abc_user
  16. GO
  17.  
  18. SELECT * FROM master.sys.database_permissions AS dp
  19. JOIN sys.system_objects AS so
  20. ON dp.major_id = so.object_id
  21. WHERE permission_name = 'EXECUTE' AND name = 'sp_OACreate'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement