Re: Secured Temp database


robert d via AccessMonster.com wrote:

> TC I appreciate your patience.

No probs :-) I may need to go in 30 minutes or so, but I am happy to
continue tomorrow.


> Please bear with me as using RWOP is the basis for my security
> and I realize now that I don't completely understand it.

You would not be the first!


> 1) I thought that the word "Owner" in RWOP meant the owner of the backend
> tables not the front-end query.

No. It is as I said before. The fundamental characteristic of an RWOP
query is that it is executed with the permissions of the user who owns
the RWOP query, regardless of which user is actually running that
query.


> 2) Then my problem is that the owner of my RWOP query (located in the front
> end) on the temp tables is not a member of the workgroup used to secure the
> model temporary database. If DBOWNER isn't a member he couldn't possibly
> have any permissions on those temporary tables. Please confirm that this is
> correct.

I haven't fully followed your existing setup since I found the
description a bit hard to follow. However, if the owner of an RWOP
query does /not/ have access to the tables referenced by that query,
then, that RWOP query will not work for anyone - that owner, or anyone
else.

When you refer to a user being (or not being) a member of several
workgroup files, remember that a user /can/ be a member of several
workgroup files. This depends on what Personal Identifier (PID) you
used when you created the user in those workgroup files. (The PID is
not the password.) Google this group for the words PID, and SID, for
yet more information!!


> I really want to make sure I understand this,

It's not easy. Digest the above, then we can continue tomorrow.

Cheers,
TC

.

Relevant Pages

  • Re: RWOP query with parameters
    ... such a query is only designed to be run with the referenced form ... an RWOP via code then you stand the danger of altering the "owner". ... You could have a basic RWOP stored of course, ... If you write a SQL statement in the Recordsource and save ...
    (microsoft.public.access.security)
  • Re: Security without signon
    ... > When you are using a workgroup file in which the owner of the RWOP ... > query /does/ exist, the query would also have the permissions of all ... For example, the RWOP ... The query would only have permissions for the BlahBlah group, ...
    (microsoft.public.access.security)
  • 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: Secured Temp database
    ... I thought that the word "Owner" in RWOP meant the owner of the backend ... Then my problem is that the owner of my RWOP query (located in the front ... workgroup file to secure both the front end and main backend. ...
    (microsoft.public.access.security)
  • Re: Object permissions
    ... Who is the owner of the query? ... permissions does the owner have on the underlying tables? ... does the user have on the query; ... to 'owners' in the sql statement each time the code runs, ...
    (microsoft.public.access.security)
Loading