Database error

[aparnakambha]

Here is the list of objects on which I have granted permission so far manually:



DBMS_REGISTRY

DBMS_REGISTRY_SERVER

XML_SCHEMA_NAME_PRESENT

SYS_STUB_FOR_PURITY_ANALYSIS

UTL_SYS_COMPRESS

DBMS_SPACE_ADMIN

DBMS_TRANSACTION_INTERNAL_SYS

DBMS_INTERNAL_LOGSTDBY





Please advice what can be done.



Thank you

[ams-jamali]

grant execute any procedure to that user.,

if it fails .,

grant sys and check

[aparnakambha]

The user is having EXECUTE_CATALOG_ROLE granted to it....

[aparnakambha]

The user is having EXECUTE_CATALOG_ROLE granted to it....

[PAVB]

The user is having EXECUTE_CATALOG_ROLE granted to it....

So what?
You keep saying whatever pop-ups on your head instead of answering our questions and consider our suggestions. Very hard to help somebody doesn't helps him/herself.
I'm officialy giving up on you. Sorry.

[aparnakambha]

Hey I will change the script like this :

declare

own varchar2(100);

nam varchar2(100);

cursor pkgs is

select owner, object_name

from dba_objects

where owner='';

begin

open pkgs;

loop

fetch pkgs into own, nam;

exit when pkgs%notfound;

sys.dbms_shared_pool.keep(own || '.' || nam, 'P');

end loop;

end;

plz help me out..plzzzzzzzzzzzzzzzzzz


But y am I getting this error......

[davey23uk]

its protecting you from the most monumentally stupid script ever, count yourself lucky

[aparnakambha]

The user is having EXECUTE_CATALOG_ROLE granted to it....