I am new to oracle and have installed 11g release 2 on a windows 2003 server.
I am working through the Oracle Warehouse Builder 11g
example.
I have gotten as far as [tutorial 4|http://www.oracle.com/technology/obe/11gr1_owb/owb11g_update_getting_started_intro/lesson4/less4_etl_mappings.htm] , but am getting an error when i get to this part:
Finally, you need to grant the "EXECUTE ANY PROCEDURE" privilege to the owf_mgr user. Connect to SQL Plus as "SYS as sysdba", and issue the command: grant execute any procedure to owf_mgr
When i issue this command i get: ORA-01917: user or role 'OWF_MGR' does not exist
The user OWF_MGR does exist and shows as open in the database config under security->user
Any ideas?
Edited by: user12179558 on 09-Nov-2009 09:04