Security problems

[RickBerem]

Hi,
Doing the security of my database the following problem occured :

On my computer the users and groups exists and everything seems ok. Except that when I open access the logon window appear and I have to enter username and p'word... even if it's not for my database...

on another computer it's worst. There's no list of users and groups... and everybody as every right to my database...

is there a way to protect only a database... and for ALL users... on ALL possible machines...

we have a network... so if someone changes the database...
it will affect me too.

Thanks

RickBerem

 

[WilsonM]

It all depends on what others should be able to do with your database.

If no one else should be able to do anything on your database then:

Create a new user in the Admin group ex.: "Superuser" (make sure that you don't forget log name and your personal ID no)

Remove the user Admin from the Admin group and set a password for that user.

Then change the ownership of all the objects in your database to your new user "Superuser"

Remove all rights from users and groups except "Superuser".

That should do the job.

Good luck,

PS: This will ask you a logon every time you open the DB, maybe I can figure something out so that you will not have to logon every time, let me know.

 

[RickBerem]

Thanks...

I already changed the ownership of the objects to my user.

the problem is if someone else opens the database from another computer( witch will be the case EVERY day )
the security is just not there... witch means that no one can use the database not even me...

I need my groups to work only on this database and work on any computer of the network... Sorry if I wasn't clear enough on my previous post... I have a hard time explaining my problems by text...

any ideas?
Thanks

RickBerem

 

[WilsonM]

Do you have an email that I could send you something?

If not here's the idea:

Put the security file (.MDW) on the network.

and create a shortcut that will open your DB and point to that (.MDW) file.

Hope I could help,

Wilson

 

[RickBerem]

yes I've got an email.

You can send me your thing to

RickBerem@hotmail.com

thanks for your help.