Designer 1.3.2 problem...

From: Fritz <fritz_nospam_at_mail4u.nl>
Date: Fri, 10 Mar 2000 16:44:35 +0100
Message-ID: <8ab37c$99u$1_at_news1.xs4all.nl>

[Quoted] Hi all,

recently I've imported a complete database, including a Designer 1.3.2. repository in a brandnew instance. To make sure that the objects would use the right tablespaces I used an user-import and everything worked fine. Since I set the grants-parameter to No (didn't have the same users and roles) I manually had to set some rights but most of it works fine by now. However when starting the Repository Object Navigator I got the error messagw 'table or view does not exist'. Somehow the user was not allowed to

[Quoted] read the table 'rm_text_lines'. Searching the schema of the repository
owner, in my case owner_des, I couldn't find any table by that name. I saw
'rm_text_types' and 'rm_text_usages' and also a 'xt_rm_text_lines'. So I've

[Quoted] created a public synonym rm_text_lines for xt_rm_text_lines and granted all [Quoted] rights to public. Everything seems to work fine by now but I have the feeling that this isn't the right way and that there might be more things that had to be done.
Can anybody help out ??

t.i.a.

B.J. Meinders
Oracle DBA
ASR-ICT Received on Fri Mar 10 2000 - 16:44:35 CET