Unanswered: regarding sp_OACreate (et al) permissions/grants
The BOL says that a users needs to be a part of the sysadmin group in order to execute this/these system stored permissions, yet I can grant EXECUTE on these to a single user not inside the sysadmin role.
Am I missing something here?
This is the query I am using to check the permissions of these stored procs:
FROM master.sys.database_permissions AS dp
JOIN sys.system_objects AS so
ON dp.major_id = so.object_id
WHERE dp.class = 1 AND so.parent_object_id = 0
AND so.name like 'sp_OA%'