Re: Setting up user group that can create and save select queries

See www.jmwild.com/MSysTables.htm

You are having this problem because of a bug with the security wizard.

Put your users in one of the wizard-created groups, as well as the group you created for them, and they'll be able to save their queries.

Another possibility is to set up RWOP queries. Then you can modify the SQL property of these queries, rather than create/save new queries. Give the users modify permissions on the query to change the SQL property in code.

--
Joan Wild
Microsoft Access MVP
"CAM" <CAM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BE3D2CE6-B690-44EF-93A2-FA8EBC16DB0F@xxxxxxxxxxxxxxxx
I want to set up a user group that can open the database and the members can
write their own queries but not be able to change any data. I have worked on
the permissions and am finally able to have the users in the group create
queries but they cannot save them as they cannot use MSysTables. I cannot
change permissions of this system table as its owner is 'Engine'. Is there
any way to set this up?

I really have three databases:
1) The data database

2) The application database used to enter and update the data; it is linked
to the data database. It has a user table used in conjunction with Access's
use-level security that controls the users & their options.

3) A third database that is also linked to the data database. It also has a
user table used in conjunction with Access's user-level security. But once a
user is allowed on this dataazsbe a database window is displayed. I want to
set permissions so the users can write select queries and then save them for
writing reports. I am able to have them create queries, and have observed
that they cannot change the data in the query output (as desired) BUT they
cannot save the query. The following messages results:
You do not have the necessary permissions to use the 'MSysTables' object.
Have your system administrator who created this object establish the
appropriate permissions for you.'

I have looked into changing the permission for this table but the owner is
"Engine", and even as the database owner I cannot make changes to the
permissions for this table.

Any suggestions? Can I even do what I am trying to do? Basically I want
some users to create their own queries and reports without being able to
accidentally change the data.

CAM
.

Relevant Pages

  • Re: User has group permissions to object, but still denied access.
    ... permissions to those query objects. ... The owners for the other 68 queries can be changed. ... may have been some of the original queries created in the database. ... Regarding the security, the database was converted from an Access 97 ...
    (microsoft.public.access.security)
  • Re: Creating security for MS Access application
    ... I wanted to create user ids and grant permissions based on user ids. ... You've not properly secured your database if that's the case. ... of User Level Security before mucking around with it too much more. ... with instructions on how to properly secure a database without the Security Wizard: ...
    (microsoft.public.access.security)
  • Re: User has group permissions to object, but still denied access.
    ... specific queries is identical to queries that she does have the ability to ... permissions depending on where the file is, it means she's either opening the ... about 80 queries in the database, and I haven't been able to find a pattern ... The Admins group was given full permissions. ...
    (microsoft.public.access.security)
  • Re: A note to add to ASPFAQ.com for database compacting
    ... I set the database directory permission to give full access to ... then checked "Allow inheritable permissions from parent to ... Thus your problem is that you have to high of security set ... > the files needed and also a compact & repair operation will not cause ...
    (microsoft.public.inetserver.asp.db)
  • Sorting out security
    ... MS Access security. ... created a new workgroup, added a password for the Admin role, added groups, ... user IDs and passwords for users and allocated permissions on the ... remote logins to a secured database. ...
    (microsoft.public.access.security)
Loading