Database Software

Hi there,

In 11.2.0.3 I'm encountering errors trying to grant workspace privs through package. For example, user SHACHE is the owner of workspace '104149843', the following grant works running as user SHACHE:

EXEC dbms_wm.GrantWorkspacePriv('ACCESS_WORKSPACE,MERGE_WORKSPACE,CREATE_WORKSPACE,REMOVE_WORKSPACE,ROLLBACK_WORKSPACE,FREEZE_WORKSPACE','104149843','AILXU','NO',FALSE);

However if the above grant is coded in a procedure/package:

CREATE OR REPLACE PROCEDURE slimadm.test_revsetgrant
IS
begin
dbms_wm.GrantWorkspacePriv('ACCESS_WORKSPACE,MERGE_WORKSPACE,CREATE_WORKSPACE,REMOVE_WORKSPACE,ROLLBACK_WORKSPACE,FREEZE_WORKSPACE','104149843','AILXU','NO',FALSE);
end;

grant execute on slimadm.test_revsetgrant to shache;

I get error trying to run this with user SHACHE:
exec slimadm.test_revsetgrant;

Error message:

[Error] Execution (30: 1): ORA-20076: insufficient privileges to grant ACCESS_WORKSPACE
ORA-06512: at "WMSYS.LT", line 10116
ORA-06512: at "SLIMADM.TEST_REVSETGRANT", line 4
ORA-06512: at line 1


The above testing works fine in 10.2.0.4.

Does OWM change security setup? Please advice.

Thanks,
Sharon