Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Stored Procedure Permissions

Author  Topic  dago Starting Member 1 Post Posted - 2005-11-10 : 06:28:49 Hi all, I have created a stored procedure (as below). This procedure is used by an access front end with some VB scripting too. The sp and all tables are owned by the dbo. The windows groups and users have been granted execute permissions on the sp. The problem I am having is when the sp is run from access by a user in a windows group that has been granted execute permissions an error 208 appears. However, if I change the owner of the sp to be my windows login, I can run it perfectly. The same happens if I change it to be explicitly owned by another user. this is the sp... CREATE PROCEDURE dbo.[qrrContract Certainty Extract](@report_start_date smalldatetime, @report_end_date smalldatetime) AS SELECT dbo.tblPolicy.PolicyReference AS [Policy Number], dbo.tblPolicy.InceptionDate AS [Inception Date], dbo.tblUnits.Description, dbo.tblPolicyTracking.DateCoverNoteSent AS [Date Cover Note Sent] FROM dbo.tblPolicy INNER JOIN dbo.tblUnits ON dbo.tblPolicy.UnitID = dbo.tblUnits.UnitID AND dbo.tblPolicy.UnitID = dbo.tblUnits.UnitID INNER JOIN dbo.tblPolicyTracking ON dbo.tblPolicy.PolicyID = dbo.tblPolicyTracking.PolicyID WHERE (dbo.tblPolicy.InceptionDate >= @report_start_date) AND (dbo.tblPolicy.InceptionDate <= @report_end_date) ORDER BY dbo.tblPolicy.InceptionDate, dbo.tblPolicy.PolicyReference Any help will be greatly appreciated.