Database Designer Issue 1

[jmanj]

I have used the query to an Oracle database using Mercator 5.0 database interface designer. The program has been running perfectly everyday until the Oracle DBA decided to delete the old userid and created a new one with almost the same priviledges as the old one. I used the new one to access the database (Sql net) but the designer is telling me that there is no tables in the database. If I use SQL plus, the new userid/password is working fine except that now everytime I do a select into a table I have to qualify it (owner???) like
ex.. select * from lawson.cbchecks;

the old userid does'nt use the "lawson." qualifier and still gets records from the table. What is the difference??

I have asked the DBA to make sure that the setup should be the same as the old userid and I was told that there should be something in the Mercator side to put the qualifier.

Is this really true? Anybody can shed me some lights on this??

Thank you very much.

We are on Sun Solaris

jmanj

 

[janhes]

That looks like an Oracle setup issue. I have had a similar thing where our databases are called name.world. I have had occasions when the DBA has set up a new database and I have had to specify the .world to get access; the dBA changed sqlnet.ora and then I didn't have to specify the .world.
So the sqlnet.ora contains
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
name.default_zone = world
automatic_ipc = off

Don't know if this helps.
Jan

 

[pgrivell]

The problem is that the table your accessing is no longer in the schema of the user you are logging on as and as far Mercator is concerned you are accessing a different table (lawson.cbcheck instead of cbcheck). You can do one of the two things:
- Ask the DBA to setup a public synonym (i.e. cbchecks pointing at lawson.cbchecks)
- Go back into the DB interface designer, change the database settings to turn off 'Access user tables/procedures only' and change your query to access the fully qualified schema.tablename

 

[jmanj]

pgrivell,

It works!!! Thanks for the tip.

jmanj