Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Whose privileges are missing?
I'm developing a db for eventual installation on my customer's server. For development, I'm using Oracle8 Personal on my development machine and my test target machine. Both are running Windows NT SP 6a. I exported my db from the development machine to the test machine.
Most things work fine on both machines, including many procedures in my
packages. However, on the test machine (only) a procedure to create a view
using DBMS_SQL gives me the message
>>
Error Number 5: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 491 ORA-06512: at "SYS.DBMS_SQL", line 32 ORA-06512: at "RWDEVELOPER.PKMAIN_SUBS", line 330 ORA-06512: at line 1
As far as I can see privileges are set up the same on the two machines. Logged on as RWDEVELOPER in SQL Plus, I can create the view on either machine using a CREATE OR REPLACE VIEW. However, logged on as another user (with the same roles and privileges on both macines) I can only do it on the development machine.
Any help would be greatly appreciated.
--Robert
Received on Wed Jun 07 2000 - 00:00:00 CDT