V4RB - Aggregate Functions, Permissions

[RB User]

On 8/26/05 5:45 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> Valentina 1.x have build results in the .ind file.
> IF db was marked as read-only, then no access to .ind file,
> So Valentina 1.x also did go to TMP folder.
> 
> But again main question:
> 
>   when second user try access is DB already opened ?
>   if yes then I think this will not work.
> 

No, only one user at a time accesses the file, using separate Mac OS X user
ids on the same machine.  For example, a parent might install my software,
but their son or daughter may use it from another "managed" Mac OS X id.

> You can have access to the same db files (shared access) only if files
> itself are marked as READ ONLY. But you say you want that one user can do
> writes ?
> 

No, the app does not write to this file, regardless of the user. All the
recordsets are read-only.

> 
> Aha, so you talk about 1.x

Yes.

> MAY BE you need to use Vserver for your task?

No, only one user needs access to this file at a time.

The thing is, I think the second user (with only read permissions to the db
file) is running the app, and Valentina is not properly handling the
permissions issue. I mean, it is trying to write the "results table" to the
db file and the user does not have write access to it, or it is trying to
build the "results table" in an invalid temp folder. This is just an
educated guess, based on the fact that the problem goes away if the user has
write access to the db file.

Should a "managed user" on OS X have write access to the system TMP folder,
that Valentina uses for the "results table"?

I don't mind leaving my workaround in place, it just makes me nervous that I
do not know 100% sure what is causing the cursor to choke.

I have verified the same problem on one other Mac OS X machine (i.e., a
managed user cannot successfully run an aggregate query cursor on a db that
they only have Read access to).

Russ