Re: permissions required for executing CDOSys stored procedures

Neile,

Actually, it is possible to GRANT EXECUTE ON sp_OACreate TO
SomeOtherPrincipal.

RLF
"Neile Bermudes" <NB@xxxxxxxxxxxxxxxx> wrote in message
news:2048E482-F053-4BFA-92F4-D77C01A2FB54@xxxxxxxxxxxxxxxx
Hi there

I'm doing some analysis on the database applications in my organisation
before migrating the databases to a new server. One of these makes use of
CDOSys objects for sending mail, instead of SQL Mail. There are a number
of
stored procedures within the database that call the sp_OACreate &
sp_OASetProperty. Apparently only members of the sysadmin role can execute
these stored procedures, however, the sql login for this application is
not a
sysadmin! I thought perhaps there was a mistake in books online but i've
looked on google and the permission requirements are the same - must be
sysadmin. Any ideas how it still manages to function without these rights?

Thanks in advance!


.

Relevant Pages

  • RE: Windows NT Security
    ... Stored Procedures offer an opportunity to improve your database security. ... Make a new login - in my case I'm using MyLogin. ... GRANT EXECUTE ON usp_ins_AUDIT_FIELD TO MyLogin ...
    (microsoft.public.sqlserver.programming)
  • Re: permissions required for executing CDOSys stored procedures
    ... that the stored procedure in the database which in turn calls the CDOSys ... stored procedures is executed via a SQL job - and thus in the context of the ... well before SQL 2000 SP3, by giving each database a different owner. ... Apparently only members of the sysadmin role can ...
    (microsoft.public.sqlserver.security)
  • Re: Changing Permissions for all Stored Procs in a SQL2005 DB
    ... already created the database role, if I do "GRANT EXECUTE TO MyNewRole", ... In SQL Server 2005 it is very easy to set the execute rights to all ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Services Security
    ... Are you debugging your SQL code on that database? ... you have to grant execute permission to the 'sp_sdidebug' stored ... Visual Studio help has some information about SQL debugging. ...
    (microsoft.public.dotnet.framework.component_services)
  • Re: Windows Services Security
    ... Are you debugging your SQL code on that database? ... you have to grant execute permission to the 'sp_sdidebug' stored ... Visual Studio help has some information about SQL debugging. ...
    (microsoft.public.dotnet.languages.vb)