|
-
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
Last edited by aparnakambha; 05-30-2008 at 03:05 AM.
-
grant execute any procedure to that user.,
if it fails .,
grant sys and check
-
The user is having EXECUTE_CATALOG_ROLE granted to it....
-
The user is having EXECUTE_CATALOG_ROLE granted to it....
-
 Originally Posted by aparnakambha
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. 
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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......
-
its protecting you from the most monumentally stupid script ever, count yourself lucky
-
The user is having EXECUTE_CATALOG_ROLE granted to it....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote