Help - user permissions

[katgirl]

Hi,

I have a database user with read-only permissions in the database.

The user would like to be able to display a list of stored procedures in the database. I would like to grant this user the permission to do this, but without granting permission to *change* the sp's in any way.

Is there a way to do this?

THANKS

 

[mrdenny]

What version of SQL?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[katgirl]

2005

 

[katgirl]

From my other post:

I would like to grant VIEW stored procedure permissions to a user in the database. I would like the user to see ALL the stored procedures in the database, just not change them in any way.

So far I have determined I can use this stmt to accomplish this task:

GRANT VIEW DEFINITION ON OBJECT:atabaseNAME.usp_StoredProc
TO User;
GO

But I am wondering - do I have to run this statement for each and every stored procedure I wish to grant user permissions on? Or is there a single stmt I can use? Like using "ALL" or something? Just want to clarify before I proceed.

Thanks

 

[mrdenny]

Se my answer in the other thead about granting view defination rights to the schema.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com