Execute Persmission denied on object 'sp_OACreate'

From: WhiskyRomeo (WhiskyRomeo_at_discussions.microsoft.com)
Date: 02/04/05

  • Next message: William Stacey [MVP]: "Re: I have been asked to leave the company for having spotted serious security breaches" 
    Date: Fri, 4 Feb 2005 14:57:05 -0800

    I have a user who has execute permissions on a store procedure in a database
    which in turns executes 4 stored procedures in the master database. These 4
    stored procedures execute a DTS package.

    Users, when given the dbo role, have no problem. Users who only have the
    Public role but execute permissions on the parent stored procedure get the
    following error.

    Execute Persmission denied on object 'sp_OACreate', database 'master', owner
    'dbo'

    How can get a user permissions to execute these stored procedures without
    assigning the dbo role. Surely I do not have to assign persmissions in the
    master database.

    Any help would be appreciated.

    WR

  • Next message: William Stacey [MVP]: "Re: I have been asked to leave the company for having spotted serious security breaches"

    Relevant Pages

    • Re: Change the login in stored procedure
      ... while granting them EXECUTE permissions on your ... them permission to execute the stored procedures. ... > Is it possible to change the login in stored procedure. ...
      (microsoft.public.sqlserver.security)
    • Sql Server - Basic Permissions Question
      ... I have a SQL Server database and I want a user to be able to execute ... stored procedures only. ... I have set EXECUTE permissions to the sp's as needed for the user. ...
      (microsoft.public.sqlserver.security)
    • Re: IIS6 - CGI wont run on new website
      ... > Sounds like your CGI is broken and needs to be debugged. ... > Your customer did not correctly configure execute permissions for the ... > instead of execute on server. ... > This configuration controls how IIS handles such ambiguous URLs. ...
      (microsoft.public.inetserver.iis)
    • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
      ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
      (microsoft.public.sqlserver.server)
    • Sybase, JDBC, AutoCommit, DDL IN TRAN
      ... having executing Sysbase stored procedures via JDBC. ... stored procedure which contains DDL and with AutoCommit set to false I ... The explanation for this behaviour I have found is that the JDBC ... I need to be able to set AutoCommit to false and execute multiple ...
      (comp.lang.java.databases)