By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,550 Members | 2,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,550 IT Pros & Developers. It's quick & easy.

User-Level secruity help

bhcob1
P: 19
Hi,

I need to add secruity to my database.

I would have just a Database Password, except this gives all users admin rights.

There are going to be 2 types of users

Admin and Read-Only

I was going to use User-Level Secruity Wizard to create this except i am under the impression that this means that you cant copy the database and drop it in diferent folders etc.

As a few of my users will be in France and a few in Australia, they where planning to copy it about once a day.

Is there any way the User-Level Sectuiry databases can be copied.

ANother question, could i just make a simple form on database open that asks for a login and password, (only 2 users Admin and Read Only), and then for every form set allowedits etc to the appropriate condition depending on the user.

Thanks
Feb 22 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
This is a complicated issue.

Have a look at this website as it provides comprehensive information.

http://www.jmwild.com/Accesssecurity.htm


Mary
Feb 23 '07 #2

NeoPa
Expert Mod 15k+
P: 31,494
Hi,

I need to add secruity to my database.

I would have just a Database Password, except this gives all users admin rights.

There are going to be 2 types of users

Admin and Read-Only

I was going to use User-Level Secruity Wizard to create this except i am under the impression that this means that you cant copy the database and drop it in diferent folders etc.

As a few of my users will be in France and a few in Australia, they where planning to copy it about once a day.

Is there any way the User-Level Sectuiry databases can be copied.

ANother question, could i just make a simple form on database open that asks for a login and password, (only 2 users Admin and Read Only), and then for every form set allowedits etc to the appropriate condition depending on the user.

Thanks
Unless you need to stop all sorts of potential access to the data, then handling this in code (driven by a logon type form) may well be a viable solution.
Feb 26 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.