hi,

i have some stored procedures that are confidential and some are not. is it possible to setup user roles to allow them to view some and not others in the same database?

thanks.