SQL Server Performance Forum – Threads Archive
Public or Private SPHello 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
GRANT ALL ON objName TO Public
GO GRANT CREATE TABLE TO all_member_invROLE
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.
http://builder.com.com/5102-6388-5061727.html http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ga-gz_8odw.asp Deepak Kumar –An eye for an eye and everyone shall be blind