Fwd: Re: Fwd: VCS - Team Coding
Aci Polajnar <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Thank you John. Everything is easy and simple, when problem is resolved. Thanks again On 3.4.2012 15:35, John Dorlon wrote: > > 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 > > fromsys.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: > > > > > > 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 > > > > I am connected to the database with DBA privileges, but pressing OK > gives me: > > > > 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 > > > ------------------------------------------------------------------------ > > No virus found in this message. > Checked by AVG - www.avg.com <http://www.avg.com> > Version: 2012.0.1913 / Virus Database: 2114/4910 - Release Date: 04/02/12 >