Urgent help needed How do you logon as different users?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you get the database to logon as different users, I
have set up the security with 2 accounts user1 and admin
with admin having full access and user1 read only, but now
everytime i logon to the database it automatically logs me
on as user1 and does not promt me to logon as the other
user, I can't access my database.
 
In order for the logon dialog to appear, you have to set a password for the
Admin user.

But before you go much further, the Admin user shouldn't have any
permissions to anything. Otherwise your database isn't secure.

Download and study the Security FAQ available at
http://support.microsoft.com/?id=207793

Be sure to follow every step outlined or your database won't be secure.
 
Back
Top