OraFAQ Forum: Server Administration » authorization issue..pls

Home » RDBMS Server » Server Administration » authorization issue..pls

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

authorization issue..pls [message #181443]

Mon, 10 July 2006 02:58

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all..

Today, i have imported a schema from one server to another..
when i try to create a procedure which have sysnonyms from another schema..it is giving the following error message..

ORA-00942: table or view does not exist

what could be the reason...
The following is the update statement failing..
in which address,sales_order_party are not been identified by the new server..

UPDATE DIM_SALES_ORDER_PARTY
SET (ENDSR_USER_ID,
ENDSR_PUB_XREF_NUM) =
(SELECT SALES_ORDER_PARTY.USER_ID,
ADDRESS.PUBLISHER_X_REF_NUMBER
FROM SALES_ORDER_PARTY, ADDRESS
WHERE DIM_SALES_ORDER_PARTY.SALES_ORDER_ID = SALES_ORDER_PARTY.SALES_ORDER_ID
AND SALES_ORDER_PARTY.ADDRESS_ID = ADDRESS.ADDRESS_ID
AND SALES_ORDER_PARTY.SALES_ORDER_PARTY_TYPE_CODE = 'ENDSR');

Thanks

Report message to a moderator

Re: authorization issue..pls [message #181448 is a reply to message #181443]

Mon, 10 July 2006 03:11

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"synonyms from another schema" - where is this "another schema"? On the first server or on the second? Can you access the underlying table/view? Did you grant proper privileges?

Because, you can create any synonym you want, even though this table/view/procedure/whatever doesn't exist:

SQL> create synonym syn_test for scott.i_dont_exist;

Synonym created.

SQL>

Report message to a moderator

Re: authorization issue..pls [message #181450 is a reply to message #181448]

Mon, 10 July 2006 03:33

sreehari
Messages: 101
Registered: May 2006

Senior Member

when i query the data dictionary...
select * from tab;
i am able to find all the synonyms in the new servers...
but when i try to query them i am getting the message like
Table or View does not exist...
what could be the reason..

Thank u

Report message to a moderator

Re: authorization issue..pls [message #181461 is a reply to message #181450]

Mon, 10 July 2006 04:07

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As I told you, synonyms were IMPORTED, but tables to which they look do not exist on the new server. You can see a synonym, but it is not valid.

Create a database link which will enable you to connect to the remote database (specifically, the user which owns those tables) and grant privileges to the user on this, new server.

Report message to a moderator

Re: authorization issue..pls [message #181498 is a reply to message #181461]

Mon, 10 July 2006 06:06

sreehari
Messages: 101
Registered: May 2006

Senior Member

OK

Actually...the schema i imported is in the same server...
do i still a need database link. or else how can i select the synonyms..

Thanks

Report message to a moderator

Previous Topic:	MAX DATAFILES
Next Topic:	database creation error - ora-01041 Internal error, hostdef extension doesn't exist,on windows2000/

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:20:49 CDT 2024