Password protect SQL - VB front end

  • Thread starter Thread starter Trev
  • Start date Start date
T

Trev

Hey,

I have a complete frontend setup, the first window/form
that shows up gives you an option of 3 databases. One of
them will only need to be accessed by about 2 - 3 people
within our organization. so i want to password protect it.

How can i do this?

I was think i can just have a funtion so that when they
click on the button for the database i want password
protected a box pops up?

Any help would be great.

Thank you.
 
Do you have a Domain controller? In that case I would simply give each user
the proper rights in the SQL database and not send a username/password pair
on the connection, safe and simple. Only drawback is that you wouldnt notice
if they got the proper rights until an SQLException is thrown, not such a
big draw back anyways.

If you dont have a domain controller then I would make one account for each
database in the SQL database. Now when the user selects a database, prompt
for the password, then send the correct username in the connection string
along with the password the user supplied. If you get an exception they
entered the wrong password.

The best part about these solutions (besides that you dont have to do much
to use them) is that the password isnt stored on the terminals, only the SQL
server/Domain controller, that way it will be harder to hack the program to
fetch the password..

Im sure there are other ways to do it too though
/Dan
 
Back
Top