How to know which user is having Exec permissions on my procedure?

Question

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

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Mahesh

Try this. But beware: if you have procedures of the same name owned by different owners then this will need a bit of refinement.

John

select o.name, user_name(p.grantee) from syspermissions p

join sysobjects o on p.id = o.id

where o.xtype = 'P'

and o.name = 'MyProc' -- Comment out to see all stored procedures

order by o.name

SQLZ SSChampion Points: 12872 More actions · Answer 2

Mahesh,

Use the system proc, sp_helprotect:

exec sp_helprotect 'dbo.MyProc'

mamidimahesh-127681 SSC Eights! Points: 868 More actions · Answer 3

SSC Eights!

Points: 868

July 17, 2006 at 12:41 am

Thanks Karl.

Mahesh