RE: Fwd: VCS - Team Coding

You need to make DBA a default role for the TOAD user

This is the query we use to detect the DBA role.  If the role isn't a default role, the query won't see it.

Select
  sum(decode(role, 'DBA', 1, 0)) dba,
  sum(decode(role, 'SELECT_CATALOG_ROLE', 1, 0)) select_catalog_role
from sys.session_roles



From: [email protected] [mailto:[email protected]] On Behalf Of Aci Polajnar
Sent: Tuesday, April 03, 2012 2:37 AM
To: [email protected]
Subject: Re: [toad] Fwd: VCS - Team Coding

Thank you Bert

Obviously, configuring team coding needs some specific privileges. I am connected to my database
as user TOAD:

[cid:[email protected]]

[cid:[email protected]]

I am able to connect as normal or SYSDBA but I get the same sad gray picture below

Regards!

On 2.4.2012 15:55, Bert Scalzo wrote:

Would not be me if I did not take this opp to remind people there are very specific reasons to connect as SYSDBA or SYSOPER - and using these does not translate into or mean DBA accont.

http://www.toadworld.com/Blogs/tabid/67/EntryId/636/TOAD-Users-Over-Use-of-SYSDBA.aspx



From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Matt Wilkins
Sent: Monday, April 02, 2012 8:36 AM
To: [email protected]<mailto:[email protected]>
Subject: RE: [toad] Fwd: VCS - Team Coding


If you are on 11.0 and are logged in as SYS, you might get the message below. Try configuring TC with a standard DBA-level user.

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Aci Polajnar
Sent: Monday, April 02, 2012 8:37 AM
To: [email protected]<mailto:[email protected]>
Subject: [toad] Fwd: VCS - Team Coding

 Hi

I am trying to configure team coding with TOAD 11.xx.
When I try with option "Configure team coding" I get

[cid:[email protected]]

I am connected to the database with DBA privileges, but pressing OK gives me:

[cid:[email protected]]

What I am doing wrong ??

Thank you and best regards!



________________________________
No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 2012.0.1913 / Virus Database: 2114/4909 - Release Date: 04/01/12