November 27, 2007 at 6:36 am
Hi
What is the minimum access permissions I can give to a user
account in sql 2005......to use stored procedures.
i keep getting
Invalid object name 'input_sp_table'.
November 29, 2007 at 8:46 am
Hi textman,
I am assuming you mean to EXECUTE a stored procedure. There is also the ability to view only the stored procedure.
Below is what I use to allow a user to have EXECUTE only permissions on ALL stored procedures within a database for the dbo schema.
USE [MyDB]
GO
GRANT EXECUTE ON SCHEMA::[dbo] TO [MyUser]
GO
To give a user the ability to view all objects but not to modify them I would use this.
use [MyDB]
GO
GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [MyUser]
GO
November 30, 2007 at 10:51 am
I agree, this would defnitely do the task..
Cheers,
John Esraelo
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply