[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Granulated security

Posted on 2002-06-13
3
Medium Priority
?
353 Views
Last Modified: 2012-08-14
Hello everybody and thank you in advance for helping me. I would like to know if there is a way to specify in Access that a person can add or delete users and also reset passwords, and that such user doesn't have to be the database owner or administrator.

Reason: We have a lot of applications in place, but we have the philosophy that the Technical are shouldn't be responsible to maintain all of the departments systems. The idea is to give liaisons permission to manage their security permission but not to give them access to manage the database.
0
Comment
Question by:insight974
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Expert Comment

by:Deebz
ID: 7077880
You'll need a security table that includes three fields: User IDs, passwords and security level.  Have the user open the database to a sign-in form.  If what's entered into the form matches what is stored in the security table, allow the database to open.  If not, quit the application.  Include an "administration" tab or button which is enabled only for certain security levels.  This button will lead to a form maintaining the security table.  
0
 
LVL 58
ID: 7078477
<<Hello everybody and thank you in advance for helping me. I would like to know if there is a way to specify
in Access that a person can add or delete users and also reset passwords, and that such user doesn't
have to be the database owner or administrator.>>

  Using the built-in Access security, the answer is no.  You need to be an admin to do any of that.  However, in code, you could open another workspace and embed a username/password, which would not be exposed to the user.  By doing this, a "normal" user could then do the stuff you want.

Take a look at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q165009

  Which tells you how to download the security FAQ, which has the code to do what you want.  I'd also suggest the Access Developers Handbook, published by Sybex for information/code for manipulating user security.

  Outside of that, you'd have to create your own security system withing Access as has already been suggested.

Jim.
0
 
LVL 5

Accepted Solution

by:
bob_online earned 300 total points
ID: 7079380
Actually, you can do it using the built in Access security.

1)  You'll need to create for form for adding users, changing passwords and the like.  You can make it look like the built in form if you want.  The form will execute update queries as needed using Owners permissions rather than user permissions.

2)  In a workgroup secured database, create a single admin type group that has rights to the form.  No other group has any rights to the form.

I did this before and it does work.  Basically you're re inventing the wheel by duplicating the built in access processes in code, but that is the only way to restrict it to a specific group.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question