So far I have received several suggestions, all of which recommend creating a
view and granting permissions to the view. However, I can't seem to get that
to work because MXJ still looks to the MAPINFO_MAPCATALOG table for the
spatial information. I imagine if I updated the catalog for each view I
could get it to work, but that seems to be a little too much work for the
number of these that I would like to create.
I have discovered that Oracle will allow you to create a function that can be
used to restrict access to a specified subset of a table. Basically, the
function is called whenever the table is queried and from within the function
you can change the WHERE clause of the select statement depending upon the
current user or other settings. This is nice because it is transparent to
the user (they think they are accessing the whole table) and doesn't require
any changes to the MAPINFO_MAPCATALOG.
However, I still can't get it to work with MXJ. For some reason, I am
getting the error "error in executing the ODCIIndexStart() routine". This is
the same error that I was receiving under different circumstances that I
posted last week. My gut feeling is that I somehow have missed some security
settings with the spatial index, but I'm not sure what or how. If anyone has
any thoughts, I'd be anxious to hear them.
Also, if anyone else out there wants to give the permissions function a try,
let me know and I'll try to explain it.
Gary.
> Sorry for this off topic post, but I'm trying to work with MapXtreme
> Java and Oracle (doing my part to toe the party line) and I was
> wondering if it was possible to restrict user's access to portions of a
> table on a record by record basis. For instance, I have a table of
> counties in Oracle. I'd like to set it up so some users can only view
> those in say New York, while others can only see California, while some
> can see all records. Is this possible with Oracle?
>
> Thanks,
> Gary.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
