How are object permissions enabled in mssql 2012?

Question

SQL Server

Specifically here. I execute the procedure on the database and gives the following error

[Microsoft][ODBC SQL Server Driver][SQL Server]Forbidden 'EXECUTE' permission on object 'sp_OACreate' of database 'mssqlsystemresource', schema 'sys'.

How can he turn it on?

Answer 1

I use MSSQL Management Studio 2008 for such tasks - there the database has a "Security" setting - each user or group can be assigned certain privileges, although you can enable everything with TSQL commands