English 中文(简体)
履历
原标题:SQL Server Access Modifiers for a function

I have a function in my database on a SQL Server 2008 R2 which calls another function based on the first parameter.

与此类似:

SlectT dbo.usp_Function1(客户X......)

This calls a different function usp_Function1CustomerX, which is specific to a customer.

这就是说,我不想有人从数据库外打电话usp_Function1CustomerX

More precise: I don t want this function to be called from code in visual studio or any OR-mapper. It would be like having an (c# term) internal access modifier for my function in the SQL Server.

任何关于如何做到这一点的想法?

Thanks, Robert

EDIT A. 从储存程序改为运作的实例

问题回答

solution 1

每人 办公室有许可证,可以修改。

solution 2

您可在内部检查的遗体上添加一栏。





相关问题
Export tables from SQL Server to be imported to Oracle 10g

I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...

SQL server: Can NT accounts be mapped to SQL server accounts

In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...

SQL Server 2000, ADO 2.8, VB6

How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8

热门标签