Geeks With Blogs

News


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done
Problem:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DEBUG_JDWP",  
ORA-06512: at "SYS.DBMS_DEBUG_JDWP_CUSTOM".
Solution:
On problematic Oracle Server, for User with insufficient privileges , execute command:\
GRANT DEBUG CONNECT SESSION TO <User> 
Background:
 SELECT *
  FROM dba_sys_privs
 WHERE grantee='<User>'
 order by privilege

SELECT *
  FROM dba_role_privs
 WHERE grantee='<User>'


 
Posted on Tuesday, May 1, 2007 10:19 AM Oracle | Back to top


Comments on this post: ORA-01031: insufficient privileges ; ORA-06512: at "SYS.DBMS_DEBUG_JDWP

# re: ORA-01031: insufficient privileges ; ORA-06512: at "SYS.DBMS_DEBUG_JDWP
Requesting Gravatar...
Wow! What a picturesque blog! I really like it. Keep on! Its always good to learn tips like you share for blog posting. That's interesting, looking forward to read more. I've became a subscriber too, so please keep me updated.
Left by custom paper on Jul 15, 2010 4:57 AM

# re: ORA-01031: insufficient privileges ; ORA-06512: at "SYS.DBMS_DEBUG_JDWP
Requesting Gravatar...
What a great post, really enjoyed reading it and was very helpful, I've only just started learning this and it has helped me out a hell of alot.
Left by red canvas on Jun 17, 2011 7:07 AM

# re: ORA-01031: insufficient privileges ; ORA-06512: at "SYS.DBMS_DEBUG_JDWP
Requesting Gravatar...
Thanks for your blog post. It helped me.
Just wanted to write so that there are not only spam comments...
Left by Daniel on Feb 09, 2012 9:11 AM

Your comment:
 (will show your gravatar)


Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net