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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-21 : 08:32:33
|
Jo writes "Using SQL Server 7.0 with Service Pack 3 on NT with service pack 5.
I currently have a stored procedure in database A Selecting records from a table in database B.
User1 has execute permissions on the stored procedure in database A and is a user within a role in database B, but has no permissions in database B. This scenario works fine on one of my servers. But fails with
SELECT permission denied on object, on two other servers. The permissions set up is the same on both servers and databases on them." |
|
|
|
|
|
Stored Procedure and permissions problems