Re: Securing Tables From Data Changes

Tech-Archive recommends: Fix windows errors by optimizing your registry

"jkmccnh" <jkmccnh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:89FBADB2-D02B-42F7-98B6-01A1191284B3@xxxxxxxxxxxxxxxx
> Sorry, 'RWOP'??. I don't know much about user-level security. We've never
> had
> anyone who either knew how, or was inclined to by-pass, the start-up
> option
> of hiding the database window. Could you please be a little more specific?
> I'm willing to read knowledge base articles but can't seem to find the
> appropriate one(s). Thanks for the help.


RWOP stands for 'run with owner permissions'. It means that you can remove
all permissions on the tables for your users. If you set the 'Run
Permissions' property to Owner rather than User, that means that anyone who
runs the query, will be able to do so as though they had the query owner's
permissions on the table.

So as long as the query owner has permissions to the underlying tables,
users will be able to access the data (because when they run the query, they
are running it 'with the query owner's permissions'); in other words, as
though the query owner was running it.

That doesn't mean that they will have full permissions to do anything
though. They are still restricted based on the permissions that the user
has on the query. So the owner may have full permissions on the tables, but
if the user has read data permission on the query, they'll only be able to
read data when they run the query.

You set the Run Permissions property in design view of the query (View,
properties menu).

--
Joan Wild
Microsoft Access MVP


.

Relevant Pages

  • Re: rwop
    ... Your clarification of rwop does help me think through the process, ... If my query doesn't ... users from entering data, but no, they will have owner's permissions. ... permissions of the owner. ...
    (microsoft.public.access.security)
  • Re: Security without signon
    ... I have never had to give the query owner explicit permissions on the tables. ... Your super user should not need to inherit any permissions from any group, ...
    (microsoft.public.access.security)
  • Re: Permissions and Object Owners
    ... If you are logging in as the owner then you should be able to change the ownership and/or permissions on the object. ... Microsoft Access MVP ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)
  • Re: restricted user level security
    ... All of my queries and macros are built off the Supervisor name, ... query, the query includes all of the fields and the CurrentUsercriteria. ... I changed the Run Permissions to Owner. ... you can set up user level security. ...
    (microsoft.public.access.security)
  • Re: Access 2002 Help required please......
    ... Thanks a million Joan think I get where you are comming from I have created ... >> Whats a RWOP query? ... that means 'run with owner permissions'. ...
    (microsoft.public.access.tablesdbdesign)