mardi 20 octobre 2015

How to deny Execute permission for bunch of stored procedure except some of them?

I have a login sa and database name called dummy and 40 stored procedures called sp1,sp2,sp3,sp4 etc.,. what is my requirement is i have to access only 2 stored procedure sp1 and sp2 in my login only.other procedure should not to access in my login.Please give any ideas.

Aucun commentaire:

Enregistrer un commentaire