Hi Gary,
this might be possible e.g. by defining views on the relevant base tables
which would include just the desired entries (CREATE VIEW yyy AS SELECT *
FROM xxx WHERE city = 'New York'). You could then grant rights on these
views to certain users and let them not use the base tables at all.
Regards,
Bjoern
-----Urspr�ngliche Nachricht-----
Von: Gary Schwartz [mailto:[EMAIL PROTECTED]]
Gesendet am: Donnerstag, 9. November 2000 15:40
An: MapInfo-L
Betreff: MI-L Slightly OT: Oracle Permissions
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.
_______________________________________________________________________
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.
