How to give permissions to a stored procedure only?

Question

Post reply

How to give permissions to a stored procedure only?

Mani-584606

SSChampion

Points: 11788
More actions
February 27, 2009 at 6:09 pm

#73516

Hi,
How to give readonly permissions to a particular stored procedure in a database in sql server 2000?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

readonly permissions?

stored procs only have EXECUTE permissions...

do you mean to read the text of procedure from sp_helptext procname,

or

permission to execute EXECUTE the procedure, but have only READONLY permission on the tables it might use?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Mani-584606 SSChampion Points: 11788 More actions · Answer 2

could you please tell me how to give execute permissions to a stored procedure from Enterprise manager(GUI). I created a login abc with default database master and I need to give access to this abc login to a stored procedure SP_ABC in database Mydb.

Thanks

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

Lookup GRANT and ROLES in Books Online... it comes free with SQL Server.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

Mani (2/27/2009)
I created a login abc with default database master and I need to give access to this abc login to a stored procedure SP_ABC in database Mydb.

have you mapped this user to the database yet

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉