The appropriate way to do this is is as follows:
select * from schema2.table;
You must have granted select permissions for the current
user within the second schema.
Please let me know if you need more information.
David Miller
> Hello,
> I wonder how I can access a table in another schema for
selects easily.
> I dont want to alter the priviliges for the table. I'd like
to do
> something like: select name from table_name_at_other_schema.
I've tried
> to create a database link but I dont know what to put in the
> connect-string clause. Any help is appreciated.
>
> Henrik
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=6942&cus_id=USENET&qtn_id=6899
Received on Wed Nov 03 1999 - 12:57:18 CST
