ORA-01933 - Help!
From: Edmond Hum <rlp_at_interlog.com>
Date: 1995/03/29
Message-ID: <3lcfto$aba_at_gold.interlog.com>#1/1
Date: 1995/03/29
Message-ID: <3lcfto$aba_at_gold.interlog.com>#1/1
Recently, we upgraded from V6 to V7.0.16 (server version). Upon running one of our .sql scripts, we encountered:
ORA-01933 error
- "cannot create a stored object using privileges from a role".
Unfortunately, we don't have the error messages guide - yet, so I'm hoping some kind soul out there could tell me what is the Oracle recommended action.
I was attempting to create a view by selecting from a sys.xxx table. It worked in V6 - so i'm a bit puzzled as to why it won't allow me to create a view in V7.
I appreciate any help!!
Thanks
edmond
Received on Wed Mar 29 1995 - 00:00:00 CEST