How do users create queries in a secured database?

  • Thread starter Thread starter dena
  • Start date Start date
D

dena

I have created a simple database and secured it with an
administrator and two users. Even though I've granted the
users permissions to all objects, they cannot create a
query in the database unless I grant them administrator
rights. Anybody else run into this & know how I can get
around it? Thanks so much. :-)

....Dena
 
I have not run into this specific issue, because I always
use the full blown security features. Sounds like you did
grant them rights, so I'm not totally sure what is going
on there.

If you're still having trouble, put another put post out
and I'll check into it.

You might want to look into the security features, which
would provide you with more control anyway. Maybe you
don't need it right now, but it's good to know for later
when you do.

I'm sure this isn't helping you much right now, but I'll
check into it if you're unable to get a solution.

http://www.moretools.com/lessons/access_security.htm

That link is just something I found... looks like it might
be helpful. Also, search in the Knowledge Base on
security, and you can find a white paper on it... that
should help as well.

I've done a lot with security over the years, but just not
with the database password as you have set up.

Hope this is of some use.
 
Rick,
Hmmm... Here's what I did. I created a database file.
Using the security wizard, I created an mdw file with
three users. One of the users (let's call him "myadmin")
I added to the Admins group, the other two I left in the
users group. I added a password to the default Admin
user, then removed him from the Admins group. After
running the security wizard I had the following; myadmin
(a member of the admins group) had rights to all objects.
The other three users (member of the users group) didn't
have any rights. I granted rights to all objects to one of
the three users, but that user still cannot create & save
a query in the database. If I add that user to the admins
group he can then create & save a query. What piece of
the security puzzle am I missing? Thanks again for the
assistance. :-)
 
Back
Top