Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.66 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 *
  19. FROM master.sys.database_permissions [dp]
  20. JOIN master.sys.system_objects [so] ON dp.major_id = so.object_id
  21. JOIN master.sys.sysusers [usr] ON
  22. usr.uid = dp.grantee_principal_id AND usr.name = 'abc_user'
  23. WHERE permission_name = 'EXECUTE' AND so.name = 'sp_OACreate'
  24.  
  25. use master
  26. grant exec on sp_OACreate to yourSecObject
  27. grant exec on sp_OADestroy to yourSecObject --Optional
  28. grant exec on sp_OAMethod to yourSecObject
  29.  
  30. The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.
  31. The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.
  32. The EXECUTE permission was denied on the object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
  33. The EXECUTE permission was denied on the object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
  34. The EXECUTE permission was denied on the object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
  35. The EXECUTE permission was denied on the object 'sp_OAGetProperty', database 'mssqlsystemresource', schema 'sys'.
  36. The EXECUTE permission was denied on the object 'sp_OAGetProperty', database 'mssqlsystemresource', schema 'sys'.
  37. The EXECUTE permission was denied on the object 'sp_OADestroy', database 'mssqlsystemresource', schema 'sys'.
  38.  
  39. EXEC sp_configure 'show advanced options', 1
  40. GO
  41. RECONFIGURE
  42. GO
  43. EXEC sp_configure 'xp_cmdshell', 1
  44. GO
  45. EXEC sp_configure 'show advanced options', 0
  46. GO
  47. RECONFIGURE
  48. GO
  49.  
  50. use [master]
  51. GO
  52.  
  53. GRANT EXECUTE ON [sys].[xp_cmdshell] TO [DOMAINusername];
  54. GRANT EXECUTE ON [sys].[sp_OACreate] TO [DOMAINusername];
  55. GRANT EXECUTE ON [sys].[sp_OADestroy] TO [DOMAINusername];
  56. GRANT EXECUTE ON [sys].[sp_OAGetErrorInfo] TO [DOMAINusername];
  57. GRANT EXECUTE ON [sys].[sp_OAGetProperty] TO [DOMAINusername];
  58. GRANT EXECUTE ON [sys].[sp_OAMethod] TO [DOMAINusername];
  59. GRANT EXECUTE ON [sys].[sp_OAStop] TO [DOMAINusername];
  60. GRANT EXECUTE ON [sys].[sp_OASetProperty] TO [DOMAINusername];
  61. GO
  62.  
  63. SELECT *
  64. FROM master.sys.database_permissions [dp]
  65. JOIN master.sys.system_objects [so] ON dp.major_id = so.object_id
  66. JOIN master.sys.sysusers [usr] ON usr.uid = dp.grantee_principal_id AND usr.name = 'DOMAINusername'
  67. WHERE permission_name = 'EXECUTE'
  68. AND (so.name = 'xp_cmdshell'
  69. OR so.name = 'sp_OACreate'
  70. OR so.name = 'sp_OADestroy'
  71. OR so.name = 'sp_OAGetErrorInfo'
  72. OR so.name = 'sp_OAGetProperty'
  73. OR so.name = 'sp_OAMethod'
  74. OR so.name = 'sp_OAStop'
  75. OR so.name = 'sp_OASetProperty')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement