Home » SQL & PL/SQL » Client Tools » Script not available in Session Browser (oracle 10.2.0.4 - Windows server 2003)
Script not available in Session Browser [message #605235] Wed, 08 January 2014 04:08 Go to next message
muktha_22
Messages: 408
Registered: December 2009
Senior Member
Hi,

Our Developer is using TOAD. for last few days they are facing a problem of not able to get script and seeing current SQL Statements.

./fa/11585/0/

Also they are not able to see the current sql statements.

Kindly tell me, which privilege needs to be granted.

Regards
Muktha
Re: Script not available in Session Browser [message #605237 is a reply to message #605235] Wed, 08 January 2014 04:14 Go to previous messageGo to next message
gazzag
Messages: 388
Registered: November 2010
Location: Bristol, UK
Senior Member
This sounds like a TOAD issue. Why not find a more appropriate forum?

HTH
-g
Re: Script not available in Session Browser [message #605250 is a reply to message #605237] Wed, 08 January 2014 04:46 Go to previous messageGo to next message
Littlefoot
Messages: 19892
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did DBA recently revoke some privileges from someone (including your developer)?

Can other developers see those information?
Re: Script not available in Session Browser [message #605255 is a reply to message #605235] Wed, 08 January 2014 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
which privilege needs to be granted.


None that a DBA will want to grant you.
If you want to see the source then use your source management tool (which Oracle is not).

Re: Script not available in Session Browser [message #605372 is a reply to message #605255] Wed, 08 January 2014 23:46 Go to previous messageGo to next message
muktha_22
Messages: 408
Registered: December 2009
Senior Member
Hi All,

I think it is not an issue of TOAD, because if i grant them the role 'SELECT_CATALOG_ROLE' or privs 'SELECT_ANY_DIRCTIONARY'
then it works. But we are not allowed to grant those.

Kindly help me out
Re: Script not available in Session Browser [message #605378 is a reply to message #605372] Thu, 09 January 2014 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Answer in my previous post.

Re: Script not available in Session Browser [message #605495 is a reply to message #605378] Thu, 09 January 2014 22:51 Go to previous message
muktha_22
Messages: 408
Registered: December 2009
Senior Member
Hi,

All

Happy to share with you all, that i found the answer.

we should grant v_$sqltext_with_newlines

Regards
Muktha
Previous Topic: how to install repository for SQL Developer
Next Topic: print text
Goto Forum:
  


Current Time: Sun Dec 21 17:37:34 CST 2014

Total time taken to generate the page: 0.09984 seconds