All Questions
4 questions
3
votes
2
answers
2k
views
SQL Server Login to access tables of three different database from single database
I have created a login in SQL Server 2008 R2 and given access to run stored procedures in that database only. But this stored procedure is actually accessing data from other two databases to which ...
- 135
10
votes
1
answer
223
views
Giving server-role to login breaks stored procedures
I have a login called user1. user1 can execute stored procedure [Test].[SP1]
EXEC [Test].[TestSortation]
EXEC [TestSortation]
Both of the above commands work.
Now if I give the user1 the server ...
- 285
9
votes
1
answer
15k
views
Rights to execute stored procedure, but not read underlying tables directly
I have a stored procedure that contains lots of different columns from many different tables; I want to give 20 users access to the results of the stored procedure via Excel.
Is it possible to make ...
- 219
1
vote
1
answer
518
views
Cannot grant execute to stored procedure [closed]
When I try to GRANT EXECUTE ON SP_NAME TO [DOMAIN\USER_NAME] on my database, I'm getting the error message below:
Msg 8115, Level 16, State 1, Procedure grant_safety, Line 5
Arithmetic overflow error ...
- 399