How do non-admin users create a query 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
 
Users do not need administer permissions to create a query. What error
message do they receive?
 
Joan,
When the user I created in my Access 2002 secured database
(who was given all rights to all objects and is a member
of the Users group) trys to create a query & then save it,
they get the following error message:

"You do not have the necessary permissions to use
the 'MSysTables' object. Have your system administrator
or the person who created this object establish the
appropriate permissions for you."

If I add that user to the Admins group, they are then able
to save a query they have created. Is there any other way
for a user who is not a member of the Admins group to be
able to create queries in the database? Thanks again for
the assistance. :-)
 
Hi dena,

dena said:
Joan,
When the user I created in my Access 2002 secured database
(who was given all rights to all objects and is a member
of the Users group) trys to create a query & then save it,
they get the following error message:
Click to expand...

Are you certain they have *all* rights to *all* objects? If they really do,
then putting them in the Admins group won't give them anything more. I
think this isn't likely.
"You do not have the necessary permissions to use
the 'MSysTables' object. Have your system administrator
or the person who created this object establish the
appropriate permissions for you."
Click to expand...

I've only seen that happen when users were modifying a query's SQL property
in code. How are your users creating queries? (by the way, it's unusual to
have an application where the users have access to the db window)
If I add that user to the Admins group, they are then able
to save a query they have created. Is there any other way
for a user who is not a member of the Admins group to be
able to create queries in the database? Thanks again for
the assistance. :-)
Click to expand...

I have not had this problem. You should be able to give users read
data/design on the tables (assuming you don't want them to
insert/update/delete). That is enough for them to create a query. Users
should not be a member of the Admins group.
 
Back
Top