Home » RDBMS Server » Server Administration » accessing tables not in the current database
accessing tables not in the current database [message #371166] Tue, 12 September 2000 03:27 Go to next message
Tom
Messages: 67
Registered: June 1998
Member
Can you access tables not under the current user name in the database you are using. I used:

SELECT .....
FROM DATABASEUSER.TABLE
WHERE.....

and the complier sends back the message that the variable hasn't been declared.

Any suggestions?
Re: accessing tables not in the current database [message #371167 is a reply to message #371166] Tue, 12 September 2000 05:49 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
observe the rules and grant's
you must have select-right on the USERNAME.TABLE
Previous Topic: Connect to multiple services
Next Topic: Help! Cannot create rollback segment @insert data
Goto Forum:
  


Current Time: Thu Mar 28 20:47:16 CDT 2024