Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NT Authentification vs SQL logins
Message
From
16/05/2002 22:03:33
Dave Sonier
Technologies Nter inc.
Gatineau, Quebec, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Security
Title:
NT Authentification vs SQL logins
Miscellaneous
Thread ID:
00657968
Message ID:
00657968
Views:
70
Hi,

What is the best thing to do in SQL Security if I don't want someone to try to connect to my database by a third party (like access)...Here's more informations about my situation...

I have a database with one table...I created a login with NT authentification...I created a role and assigned this role to my logins...Next, I defined a security (Select, Insert, Delete, Update) on my table...With my vb6 interface, I developed a form an used my table...But each user can insert, update or delete only own's row by department...

But I don't want someone use Access using ODBC to go delete all my table with my Nt authentification logins...

I hope that I explain my problem clearly...

Thank in advance...
Next
Reply
Map
View

Click here to load this message in the networking platform