| plsql developer problem [message #314394] |
Wed, 16 April 2008 10:07  |
swas_fly
Messages: 57
Registered: March 2008
Location: Bhubaneswar |
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  |
sdhanuka
Messages: 88
Registered: March 2008 |
Member |
|
|
Post your error
[Updated on: Wed, 16 April 2008 10:22]
|
|
|
| Re: plsql developer problem [message #314508 is a reply to message #314394 ] |
Thu, 17 April 2008 00:09 |
swas_fly
Messages: 57
Registered: March 2008
Location: Bhubaneswar |
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 |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
sdhanuka
Messages: 88
Registered: March 2008 |
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 |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
swas_fly
Messages: 57
Registered: March 2008
Location: Bhubaneswar |
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 |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
swas_fly
Messages: 57
Registered: March 2008
Location: Bhubaneswar |
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 |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
Frank
Messages: 5231
Registered: April 2002
Location: NL |
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.
|
|
|
]
Members
Search
Help
Register
Login
Home
