Permission denied calling secondary database SP from another database SP

From: Tomas Hellström (anonymous_at_discussions.microsoft.com)
Date: 10/31/03 

Date: Fri, 31 Oct 2003 01:17:41 -0800

A user has EXECUTE permission (thru membership of a user
group) on a Stored Procedure in a SQL Server 7.0 sp3
database. dbo owns the database and all objects. The
stored procedure access a table in a different database
on the same server. What rights does the user have
towards that table? The user can execute the stored
procedure and thru it do both SELECT and INSERT on the
table. On a test installation (another server) the user
gets permission denied on both SELECT and INSERT. The
problem is why do we get permission denied on the test
server (or why not on the production server)? The servers
have the same configuration for permissions. Is it a
general configuration to allow cross database rights?

Does antbody know this?

Relevant Pages

  • Re: dumb++ security
    ... If the user doesn't have permission ... > to connect to either database, ... Proud Member of the Exclusive "I have been plonked by Davee because he ... > database/some server to perform task A. ...
    (comp.security.misc)
  • Re: dumb++ security
    ... If the user doesn't have permission ... > to connect to either database, ... Proud Member of the Exclusive "I have been plonked by Davee because he ... > database/some server to perform task A. ...
    (comp.security.unix)
  • Re: Creating a database
    ... Please do yourself a favor, find a local user group, or buy a beginning book on SQL Server or take a class, you will save yourself a great deal of pain in the long run. ... CREATE DATABASE Products ... I can create a stored procedure from within the Server Explorer and from ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: WSS 3.0 Search Service
    ... was trying to access the database server to create the search database, ... I changed it to SQL server authentication and it was able ... I keep getting redirected back to the configuration page. ... The application-specific permission settings do not grant Local ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: user permissions
    ... Server 2003): ... permission in both the Sharing permission and Security permission. ... since abc can logon to the server and access the ... database locally, it seems that it has enough security permission. ...
    (microsoft.public.sqlserver.server)