SQL Server Performance Forum – Threads Archive

Private procedures

In PL/SQL you can have package-private procedures which can only be run from within the package. I want to expose an API of one or two procedures to the user (he’s using a DAO) and have several ‘private’ utility procedures/functions. Is there any way to enforce this? If not is there perhaps a standard naming convention, like prefixing ‘private’ procedures with ‘_’

---

Does not have similar. But you can selectively grant the execute permission of the stored procedure to user
KH

---

]]>