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?

Report message to a moderator

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: 7897
Registered: March 2000
Senior Member
observe the rules and grant's
you must have select-right on the USERNAME.TABLE

Report message to a moderator

Previous Topic: Connect to multiple services
Next Topic: Help! Cannot create rollback segment @insert data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 23 08:47:09 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.