associates
IS-IT--Management
Hi,
I've read some threads regarding database security. I have just set up security for my database using the user-level security wizard for a start recommended by microsoft support. At the same time, it created a workgroup file and stored into system1.mdw. Once done, i went to create a password by going to tools -> security -> set database password. However, i got a pop-up dialog box saying "you need to have the database open for exclusive use to set or unset the database password".
Another question is that i noticed some people talking about log in as user1. Is that mean i need to log out from windows and login as another user.
Sorry for asking silly question but i really don't know as this is my first time i have attempted to create security.
Thank you for your help in advance.
I've read some threads regarding database security. I have just set up security for my database using the user-level security wizard for a start recommended by microsoft support. At the same time, it created a workgroup file and stored into system1.mdw. Once done, i went to create a password by going to tools -> security -> set database password. However, i got a pop-up dialog box saying "you need to have the database open for exclusive use to set or unset the database password".
Another question is that i noticed some people talking about log in as user1. Is that mean i need to log out from windows and login as another user.
Sorry for asking silly question but i really don't know as this is my first time i have attempted to create security.
Thank you for your help in advance.