OraFAQ Forum: Client Tools » Script not available in Session Browser

Home » Other » Client Tools » Script not available in Session Browser (oracle 10.2.0.4 - Windows server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Script not available in Session Browser [message #605235]

Wed, 08 January 2014 04:08

muktha_22
Messages: 527
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.

/forum/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

Attachment: Schema Browser issue.JPG
(Size: 12.39KB, Downloaded 1037 times)

Report message to a moderator

Re: Script not available in Session Browser [message #605237 is a reply to message #605235]

Wed, 08 January 2014 04:14

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

This sounds like a TOAD issue. Why not find a more appropriate forum?

HTH
-g

Report message to a moderator

Re: Script not available in Session Browser [message #605250 is a reply to message #605237]

Wed, 08 January 2014 04:46

Littlefoot
Messages: 21781
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?

Report message to a moderator

Re: Script not available in Session Browser [message #605255 is a reply to message #605235]

Wed, 08 January 2014 04:55

Michel Cadot
Messages: 68500
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).

Report message to a moderator

Re: Script not available in Session Browser [message #605372 is a reply to message #605255]

Wed, 08 January 2014 23:46

muktha_22
Messages: 527
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

Report message to a moderator