Re: cannot create view of rm_text_lines in Process Modeller

Someone determined that the problem that I face is that I do not have the permissions to create views (or need them to run Designer 2000), and that ORA-00942: table or view does not exist is Oracle's twisted way of saying that I am not permitted to use that table for creating views.

Valery's suggestion below might indeed work, presuming that the user JETHRO has those view creation rights that I lack (I am not in the position to run a test of this theory).

In article <364ADB4F.EF9C29DC_at_dd.ru>,   "Valery A. Sorokin" <vsorokin_at_dd.ru> wrote:
> Try to login with SQL*Plus as JETHRO and use this statement:
>
> CREATE VIEW JED( TEXT, ID )
> AS ( SELECT TXT_TEXT, TXT_REF FROM RM_TEXT_LINES );
>
> Then you can create any synonym to this VIEW and grant privileges...
>
> I hope this will help you.
>
> eschen42_at_my-dejanews.com wrote:
> >
> > We are running designer 2000 version 2.1
> > (The repository is a database that is on a server running Oracle 8.0.4 for
NT)
> >
> > I want to create a view of the RM_TEXT_LINES table.
> > Any ideas why SQL*PLUS won't let me :( ?
> >
> > Here's a transcript of my SQL*PLUS session:
> >
> > SQL> ;
> > 1 CREATE VIEW JED( TEXT, ID )
> > 2* AS ( SELECT TXT_TEXT, TXT_REF FROM JETHRO.RM_TEXT_LINES )
> > SQL> /
> > AS ( SELECT TXT_TEXT, TXT_REF FROM JETHRO.RM_TEXT_LINES )
> > *
> > ERROR at line 2:
> > ORA-00942: table or view does not exist
> >
> > SQL> DESC JETHRO.RM_TEXT_LINES
> > Name Null? Type
> > ------------------------------- -------- ----
> > TXT_REF NOT NULL NUMBER(38)
> > TXT_SEQ NOT NULL NUMBER(6)
> > TXT_TYPE NOT NULL VARCHAR2(10)
> > TXT_TEXT VARCHAR2(2000)
> > TXT_NOTM NUMBER(38)
> >
> > SQL> SELECT * FROM user_synonyms
> > 2 WHERE SYNONYM_NAME = 'RM_TEXT_LINES';
> >
> > SYNONYM_NAME TABLE_OWNER
> > ------------------------------ -------------
> > TABLE_NAME
> > ------------------------------
> > DB_LINK
> > --------------------------------------------
> > RM_TEXT_LINES JETHRO
> > RM_TEXT_LINES
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> --
> Valery A. Sorokin
> ProSoft, Russia, Moscow, Information Systems Division
> Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
> E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su
> http://www.dd.ru
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 19 1998 - 18:15:40 CET