Permissions on sp_OASetProperty

We have a request to be able to execute the following from an application:

declare @languageValue varchar(1000)
exec sp_OASetProperty @languageValue, 'CharSet', 'Shift-JIS'

Currently the developer is unable to because they get an "EXECUTE permission
denied on object 'sp_OASetProperty', database 'master', owner 'dbo'." when
running this.

We have no users (other than dbo & guest) in the master database. How can
this be setup with the least amount of permissions being given.

I appreciate any suggestions.

thanks
Meenal






.

Relevant Pages

  • Re: xp_cmdShell
    ... checkbox under SQL Server Agent properties --> Job ... System) and specify a Windows account for the SQL Agent proxy with the ... > I thought if he has execute permission for my sp, which owner is DBO, that ... If I set the execute permission for 'xp_cmdshell' to my read user I get the ...
    (microsoft.public.sqlserver.programming)
  • Re: NX bit versus standard permissions?
    ... Section is not a segment neither a page. ... Now, if the CPU has no way to enforce NX, the execute permission is ... x86 CPUs could *only* enforce ... Fortunately tools have been good about setting the execute bit in the code ...
    (comp.lang.asm.x86)
  • Re: Weird Permissions Problem With Includes
    ... Yes that is the weird thing, I gave read and execute permission to the ... PHP scripts are not executed. ... calling PHP scripts from the command line, cron jobs, etc. ...
    (comp.lang.php)
  • Re: du command failing
    ... directory if the directory does not have a Read or Execute permission. ... From UNIX command line i have executed 'du' command. ... From [exec] manpage: ...
    (comp.lang.tcl)
  • Re: Stored Procedures in the Master Database
    ... I tried qualifying the grant ... >If you are indeed in the master database when you run ... >> I have a stored procedure that I want to make available ... >> When I try to execute the stored procedure from another ...
    (microsoft.public.sqlserver.security)