General information
Forum:
Microsoft SQL Server
Title:
NT Authentification vs SQL logins
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only