Re: executing a stored procedure causes an OACreate errors
From: Gregory A. Larsen (greg.larsen_at_netzero.com)
Date: 08/27/04
- Next message: Mike Schinkel: "Re: Space required for an empty varchar field?"
- Previous message: David Portas: "Re: Phone number dup checking and removal"
- In reply to: Harjinder Singh: "executing a stored procedure causes an OACreate errors"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 27 Aug 2004 14:42:10 -0700
Only members of the sysadmin's server role can execute "sp_OA..." stored
procedures. The sa users is in this server role.
-- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- - Need SQL Server Examples check out my website http://www.geocities.com/sqlserverexamples "Harjinder Singh" <harjinder.singh@paramount.com> wrote in message news:%23ZHk%23AHjEHA.3944@tk2msftngp13.phx.gbl... > When i call a stored procedure as a user, i get the following errors: > > EXECUTE permission denied on object 'sp_OACreate', database 'master', owner > 'dbo'. > > EXECUTE permission denied on object 'sp_OASetProperty', database 'master', > owner 'dbo'. > > > > > > When i run the stored procedure as 'sa' I don't get any errors, > > however when i run the procedure as a restricted user who has exec rights > on the stored procedure then i get these errors... > > > any advice? > > Thanks, > > >
- Next message: Mike Schinkel: "Re: Space required for an empty varchar field?"
- Previous message: David Portas: "Re: Phone number dup checking and removal"
- In reply to: Harjinder Singh: "executing a stored procedure causes an OACreate errors"
- Messages sorted by: [ date ] [ thread ]
