Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Security within a VB Application

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-03 : 07:26:23
Guy writes "Hello -

How can I set up SQL Server 2000 security so that users of my VB6 application can interact with tables (Select, Insert, Update, Delete) only within the application?

In other words, I want to block them from linking to my tables from outside the VB6 application.

Any advice appreciated.

Thanks much.

Guy"

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-07-03 : 17:27:02
Have a look at application roles in BOL


HTH
Jasper Smith

0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27
Go to Top of Page
   

- Advertisement -