We are looking to secure SQL Object (View, Stored Procedures, and possibly tables and Schema's). Has anyone already done this either using Internal or External Security? Is so, any you able to share any examples as I'm finding the Security documentation somewhat limited and confusing.
I was wondering if it would be possible to secure a Stored Procedure as a PROGRAM.
Thanks, Ian Cameron