Business scenario: not everybody is allowed to see everything.
Steps to set this up:
- load table with Easyloader into Oracle, say tablename xyz. This will
also create a spatial index.
- create public synonym xyx for owner.xyz
- create role read_role ;
- grant select on xyz to read_role;
- grant select on xyz_..rt$ (or whatever the name of the spatial
index table is) to read_role. This makes the indexes visible for Mapinfo.
In some cases I've seen errors about differing coordinate systems and the like, these are meant to confuse you.
You now open the table in Mapinfo, save it somewhere, no caching, no linked data.
My question: how can I force Mapinfo to only ask *once*
for a Oracle username/password? In the local TAB file (pointing to Oracle)
something is stored like:
"\DATALINK\ConnectionString" = "SRVR=LOCAL;UID=scott"
if I have 2 tables in my workspace, MI asks twice for a UN/PW when the
guy logging in (via the synonym) <> UID.
Three files, 3 * logging in. This will drive any user up the wall.
Removing the UID entry has no effect.
Please advice ..
Thanks,
Floris Versteeg
[EMAIL PROTECTED]
