Home » SQL & PL/SQL » Client Tools » plsql developer problem (XP,Oracle 10g)
plsql developer problem [message #314394] Wed, 16 April 2008 10:07 Go to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
Hi

I am not able to use the debug execute button for executing my programs,It was first in the enable step but when i first time pressed i got the error message as
insufficient priviledges enable some debug session etc.
Sorry i don't remember the exact message,But then i haven't been able to use this buttion(which facilitates step by step execution)

This is now in the disable state....


Please help how to make it work.
Thanks
Re: plsql developer problem [message #314397 is a reply to message #314394] Wed, 16 April 2008 10:17 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Post your error

[Updated on: Wed, 16 April 2008 10:22]

Report message to a moderator

Re: plsql developer problem [message #314508 is a reply to message #314394] Thu, 17 April 2008 00:09 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
ORA-0131:Insufficient Priviledges
Debugging requires Debug connect session system priviledges

Re: plsql developer problem [message #314514 is a reply to message #314508] Thu, 17 April 2008 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to grant you this privilege.

Regards
Michel
Re: plsql developer problem [message #314533 is a reply to message #314514] Thu, 17 April 2008 01:39 Go to previous messageGo to next message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
Hey Michel cant we connect as a sysdba and grant user privileges?
Re: plsql developer problem [message #314536 is a reply to message #314533] Thu, 17 April 2008 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sysdba is for database maintenance purpose.
Use a DBA for privileges.

Regards
Michel
Re: plsql developer problem [message #314537 is a reply to message #314394] Thu, 17 April 2008 01:46 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
I have tried that but it again says that no priviledges for connection as sysdba
Re: plsql developer problem [message #314538 is a reply to message #314537] Thu, 17 April 2008 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who say you to use sysdba?
Don't use it but for maintenance purpose.

Regards
Michel
Re: plsql developer problem [message #314539 is a reply to message #314538] Thu, 17 April 2008 01:52 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
I cannot use it as we don't have priviledges.I think i made it clear in the previous point
Re: plsql developer problem [message #314542 is a reply to message #314539] Thu, 17 April 2008 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to grant you the privilege, I think I made it clear in a previous post.

Regards
Michel
Re: plsql developer problem [message #314546 is a reply to message #314539] Thu, 17 April 2008 02:22 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You seem to be missing a point here.
Connecting as a DBA user is not the same as connecting as sysdba.
A DBA user connects as normal; it's just a user that has extended privileges granted to him.
Connecting "as sysdba" should be reserved for system-maintenance tasks.
Previous Topic: spool append
Next Topic: Command line parameters for sql script ?
Goto Forum:
  


Current Time: Sun Dec 04 10:25:43 CST 2016

Total time taken to generate the page: 0.09491 seconds