with only read access, How can you view the stored proc?

Question

with only read access, How can you view the stored proc?

tomson

Newbie

Points: 1
More actions
June 18, 2010 at 7:18 am

#222884

with only read access, How can you view the stored proc?

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

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

Grant Fritchey SSC Guru Points: 399340 More actions · Answer 1

You can't. You'd need to have execute privs on the procedure in order to execute it and get the data back from it.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 2

If you just want to view the proc, you can grant view definition rights on it.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grant Fritchey SSC Guru Points: 399340 More actions · Answer 3

GilaMonster (6/18/2010)
If you just want to view the proc, you can grant view definition rights on it.

Oh right, I was thinking about looking at the data... misread it. Good catch, thanks.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning