Re: Designer 1.3.2 problem...

You should have run RAU (repository administrator utility, which can be reached in RON) to regrant specific users. You should use it know to reconcile any differences.

Hth,

Sybrand Bakker, Oracle DBA

Fritz <fritz_nospam_at_mail4u.nl> wrote in message news:8ab37c$99u$1_at_news1.xs4all.nl...
> 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
> 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
> created a public synonym rm_text_lines for xt_rm_text_lines and granted
all
> 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 - 20:02:20 CET