Home » Developer & Programmer » Warehouse Builder » mapping problem
mapping problem [message #417195] Thu, 06 August 2009 07:59 Go to next message
zoozoo
Messages: 1
Registered: August 2009
Junior Member
hi there,

i wanna extract some data from a relational table into a dimension and a cube.

all sequences, tables, dimensions and cubes deploy fine.

but when im gonna deploy the mappings the following error occurs.

ORA-06550: line 133, column 24:
PLS-00904: not sufficient privileges to access the object SYSTEM.WB_RT_MAPAUDIT


whats the matter?

does anybody got the same problem?

many thx
Re: mapping problem [message #417239 is a reply to message #417195] Thu, 06 August 2009 12:38 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that you don't have required privileges in order to access SYSTEM owned object whose name is WB_RT_MAPAUDIT. (Do you really want / need to work with SYSTEM objects?)

Oracle
ORA-06550: line string, column string: string

Cause: Usually a PL/SQL compilation error.

Action: none
Oracle
PLS-00904: insufficient privilege to access object string

Cause: An attempt was made to operate on a database object without the required privilege. This error occurs, for example, if an attempt was made to UPDATE a table for which only SELECT privileges were granted.

Action: Ask the DBA to perform the operation or to grant you the required privilege.
Previous Topic: owb hang creating/designing/editing cube
Next Topic: For loop in OWB
Goto Forum:
  


Current Time: Fri Dec 02 16:54:56 CST 2016

Total time taken to generate the page: 0.11686 seconds