Public or Private SP | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Public or Private SP

Hello Friends, Do you have any idea how you can implement private or public sp in SQL server. I have a requirement where in i have to include some SP as public which can be access by any user and some SP as private which can be access by only few user.I am aware that we can do so by adding roles, Is there is any way out. Please provide your inputs. Thanks and Regards Ravi Kumar
read about
GRANT ALL ON objName TO Public
all in BOL

In SQL Public or Private do not work; but you have fixed server and database Roles for users, you need to select appropriate roles and give permissions on required database objects. Deepak Kumar –An eye for an eye and everyone shall be blind