Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Security Chain
Message
 
To
17/08/2006 13:46:08
General information
Forum:
Microsoft SQL Server
Category:
Security
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01146399
Message ID:
01146503
Views:
22
>Chad,
>
>Both .NET Data Access and VFP use SP_ExecuteSQL to do their work with SQL Server. Check the profiler and you'll see this.

Ken,

That is true, but that is more internal than what you described you were trying to do. If all you want to do is to limit access to the table except from within your app, you could create a SQL Authentication account that your application uses to connect and then don't add any Windows authentication access for user 'Bob'. Would something like that not work for you?

Chad
_________________________________
There are 2 types of people in the world:
    Those who need closure
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform