Toad World® Forums

Enable Team Coding when can't use DBA connection


#1

Hi,

First post to ToadWorld (gentleness appreciated).

I would like to add Team Coding to Toad for Oracle 12.1.0.22, but I am not permitted to login with a DBA connection. I was able to get system DBA folks to create a user (TOAD_OWNER) with the required permissions. I have successfully run the TC Install Script as that TOAD_OWNER user. I believe all of the server side objects and permissions needed have been created, but the Utilities | Team Coding | Confifure Team Coding screen produces the

Team Coding is not installed. A DBA Session is required to install Team Coding Objects.

popup. Getting past the popup, the Enable Team Coding for this Database checkbox is grayed out.

I cannot have my admins login using Toad with a DBA connection as they are not in my location and they cannot remotely control my instance of Toad.

How can I inform Toad that the Team Coding Objects have indeed been installed?

Vince


#2

From what you mentioned, it sounds like the objects weren’t installed on the database your connecting to or something went wrong with the install and the tables weren’t created for some reason. Go into Schema Browser, and change the schema to the one you installed the objects into (most likely ‘Toad’ unless you changed it during setup) - select ‘Tables’. Below is a list of the TC tables that should have been installed (TC_xxxxx).

1007.pic.jpeg

If these are installed correctly, then when you login to that database and go to the TC Configuration window as your normal user, it should tell you that all the settings are read-only, because you don’t have the Admin role. In your case, it’s saying it’s not installed, so I would verify that your install worked correctly.

4718.pic2.jpeg


#3

Also be sure that a public synonym called QUEST_COM_TEAM_CODING was created for the table TC_CONFIG

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]

Sent: Thursday, July 02, 2015 8:38 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Dennis Paulus

From what you mentioned, it sounds like the objects weren’t installed on the database your connecting to or something went wrong with the install and the tables weren’t created for some reason.
Go into Schema Browser, and change the schema to the one you installed the objects into (most likely ‘Toad’ unless you changed it during setup) - select ‘Tables’. Below is a list of the TC tables that should have been installed (TC_xxxxx).

If these are installed correctly, then when you login to that database and go to the TC Configuration window as your normal user, it should tell you that all the settings are read-only, because
you don’t have the Admin role. In your case, it’s saying it’s not installed, so I would verify that your install worked correctly.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#4

Dennis,

Thanks so much for the quick reply! I checked the tables, all the TC_ tables appeared but not the TCX_ tables. To be sure I did it correctly, I dropped all tables and sequences on the TOAD_OWNER schema, and reran a fresh copy of the TC Install script. After running the script that had no errors, I got the following:

SQL> select table_name from user_tables;

TC_FILEEXT

TC_OBJSTATUS

TC_OBJSTATUS_VCS

TC_GROUP

TC_MASK

TC_USERMAPPING

TC_ALL_OBJECTS

TC_ALL_OBJ_MASK

TC_CONFIG

TC_TIMESTAMP

10 rows selected.

Elapsed: 00:00:00.25

SQL>

I still get the same results when I go to the Utilities | Team Coding menu.

Can you tell me what Toad is looking for in order to determine that Team Coding has been correctly installed?


#5

Brad,

Thanks for that thought. It looks like this synonym was created successfully:

SQL>

SQL> Prompt Creating public synonym QUEST_COM_TEAM_CODING

Creating public synonym QUEST_COM_TEAM_CODING

SQL> CREATE OR REPLACE PUBLIC SYNONYM QUEST_COM_TEAM_CODING FOR &&OWNER…TC_CONFIG;

old 1: CREATE OR REPLACE PUBLIC SYNONYM QUEST_COM_TEAM_CODING FOR &&OWNER…TC_CONFIG

new 1: CREATE OR REPLACE PUBLIC SYNONYM QUEST_COM_TEAM_CODING FOR TOAD_OWNER.TC_CONFIG

Synonym created.

Elapsed: 00:00:00.03

SQL>

Vince Iacoboni

Solution Architect | Tel. 410-895-5253 Deutsche Bank Securities Inc.

Global Technology Core Banking

Mail Stop BAL01-1305, Baltimore, MD

Email vince.iacoboni@db.com

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Thursday, July 02, 2015 8:48 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Brad Boddicker

Also be sure that a public synonym called QUEST_COM_TEAM_CODING was created for the table TC_CONFIG

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]

Sent: Thursday, July 02, 2015 8:38 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Dennis Paulus

From what you mentioned, it sounds like the objects weren’t installed on the database your connecting to or something went wrong with the install and the tables weren’t created for some reason.
Go into Schema Browser, and change the schema to the one you installed the objects into (most likely ‘Toad’ unless you changed it during setup) - select ‘Tables’. Below is a list of the TC tables that should have been installed (TC_xxxxx).

If these are installed correctly, then when you login to that database and go to the TC Configuration window as your normal user, it should tell you that all the settings are read-only, because
you don’t have the Admin role. In your case, it’s saying it’s not installed, so I would verify that your install worked correctly.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#6

Also verify that the user TOAD_OWNER has the TC_ADMIN role

I assume you’re opening the TC Admin window as TOAD_OWNDER?

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 9:18 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Brad,

Thanks for that thought. It looks like this synonym was created successfully:

SQL>

SQL> Prompt Creating public synonym QUEST_COM_TEAM_CODING

Creating public synonym QUEST_COM_TEAM_CODING

SQL> CREATE OR REPLACE PUBLIC SYNONYM QUEST_COM_TEAM_CODING FOR &&OWNER…TC_CONFIG;

old 1: CREATE OR REPLACE PUBLIC SYNONYM QUEST_COM_TEAM_CODING FOR &&OWNER…TC_CONFIG

new 1: CREATE OR REPLACE PUBLIC SYNONYM QUEST_COM_TEAM_CODING FOR TOAD_OWNER.TC_CONFIG

Synonym created.

Elapsed: 00:00:00.03

SQL>

Vince Iacoboni

Solution Architect | Tel. 410-895-5253 Deutsche Bank Securities Inc.

Global Technology Core Banking

Mail Stop BAL01-1305, Baltimore, MD

Email vince.iacoboni@db.com

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Thursday, July 02, 2015 8:48 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Brad Boddicker

Also be sure that a public synonym called QUEST_COM_TEAM_CODING was created for the table TC_CONFIG

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]

Sent: Thursday, July 02, 2015 8:38 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Dennis Paulus

From what you mentioned, it sounds like the objects weren’t installed on the database your connecting to or something went wrong with the install and the tables weren’t created for some reason.
Go into Schema Browser, and change the schema to the one you installed the objects into (most likely ‘Toad’ unless you changed it during setup) - select ‘Tables’. Below is a list of the TC tables that should have been installed (TC_xxxxx).

If these are installed correctly, then when you login to that database and go to the TC Configuration window as your normal user, it should tell you that all the settings are read-only, because
you don’t have the Admin role. In your case, it’s saying it’s not installed, so I would verify that your install worked correctly.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#7

There might be something with that custom schema your using. If you can, I would drop that schema and try installing into the standard TOAD schema by just
taking the defaults - the install script will create the schema and everything that is needed. Kind of sounds like something is getting mucked up with that custom schema, but that’s just a guess.

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 9:11 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Dennis,

Thanks so much for the quick reply! I checked the tables, all the TC_ tables appeared but not the TCX_ tables. To be sure I did it correctly, I dropped all tables and sequences on the TOAD_OWNER
schema, and reran a fresh copy of the TC Install script. After running the script that had no errors, I got the following:

SQL> select table_name from user_tables;

TC_FILEEXT

TC_OBJSTATUS

TC_OBJSTATUS_VCS

TC_GROUP

TC_MASK

TC_USERMAPPING

TC_ALL_OBJECTS

TC_ALL_OBJ_MASK

TC_CONFIG

TC_TIMESTAMP

10 rows selected.

Elapsed: 00:00:00.25

SQL>

I still get the same results when I go to the Utilities | Team Coding menu.

Can you tell me what Toad is looking for in order to determine that Team Coding has been correctly installed?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#8

Dennis,

Unfortunately not an option. Our standards do not permit us to create a schema ourselves, and the DBAs requires that it be in the format of *_OWNER. I wouldn’t
be surprised if there was something related to the custom schema name, but I’m at the point where I must find out what that something is.

Is there any way to use TOAD to find out what server-side checks it is performing when the Utilities | Team Coding | Configure Team Coding menu option is chosen?

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]

Sent: Thursday, July 02, 2015 9:35 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Dennis Paulus

There might be something with that custom schema your using. If you can, I would drop that schema and try installing into the standard TOAD schema by just
taking the defaults - the install script will create the schema and everything that is needed. Kind of sounds like something is getting mucked up with that custom schema, but that’s just a guess.

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 9:11 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Dennis,

Thanks so much for the quick reply! I checked the tables, all the TC_ tables appeared but not the TCX_ tables. To be sure I did it correctly, I dropped all tables and sequences on the TOAD_OWNER
schema, and reran a fresh copy of the TC Install script. After running the script that had no errors, I got the following:

SQL> select table_name from user_tables;

TC_FILEEXT

TC_OBJSTATUS

TC_OBJSTATUS_VCS

TC_GROUP

TC_MASK

TC_USERMAPPING

TC_ALL_OBJECTS

TC_ALL_OBJ_MASK

TC_CONFIG

TC_TIMESTAMP

10 rows selected.

Elapsed: 00:00:00.25

SQL>

I still get the same results when I go to the Utilities | Team Coding menu.

Can you tell me what Toad is looking for in order to determine that Team Coding has been correctly installed?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#9

Yes, it has the role:

SQL> select * from user_role_privs;

USERNAME GRANTED_ROLE ADM DEF OS_


TOAD_OWNER DB_CATALOG_ROLEV11203 NO NO NO

TOAD_OWNER DB_CONNECT NO NO NO

TOAD_OWNER TC_ADMIN_ROLE YES YES NO

TOAD_OWNER TOAD_OWNER_ROLE NO NO NO

Elapsed: 00:00:00.03

SQL>

And yes, opening the TC Admin window as TOAD_OWNER (see attachment)

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Thursday, July 02, 2015 9:35 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Brad Boddicker

Also verify that the user TOAD_OWNER has the TC_ADMIN role

I assume you’re opening the TC Admin window as TOAD_OWNDER?

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 9:18 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Brad,

Thanks for that thought. It looks like this synonym was created successfully:

SQL>

SQL> Prompt Creating public synonym QUEST_COM_TEAM_CODING

Creating public synonym QUEST_COM_TEAM_CODING

SQL> CREATE OR REPLACE PUBLIC SYNONYM QUEST_COM_TEAM_CODING FOR &&OWNER…TC_CONFIG;

old 1: CREATE OR REPLACE PUBLIC SYNONYM QUEST_COM_TEAM_CODING FOR &&OWNER…TC_CONFIG

new 1: CREATE OR REPLACE PUBLIC SYNONYM QUEST_COM_TEAM_CODING FOR TOAD_OWNER.TC_CONFIG

Synonym created.

Elapsed: 00:00:00.03

SQL>

Vince Iacoboni

Solution Architect | Tel. 410-895-5253 Deutsche Bank Securities Inc.

Global Technology Core Banking

Mail Stop BAL01-1305, Baltimore, MD

Email vince.iacoboni@db.com

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Thursday, July 02, 2015 8:48 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Brad Boddicker

Also be sure that a public synonym called QUEST_COM_TEAM_CODING was created for the table TC_CONFIG

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]

Sent: Thursday, July 02, 2015 8:38 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Dennis Paulus

From what you mentioned, it sounds like the objects weren’t installed on the database your connecting to or something went wrong with the install and the tables weren’t created for some reason.
Go into Schema Browser, and change the schema to the one you installed the objects into (most likely ‘Toad’ unless you changed it during setup) - select ‘Tables’. Below is a list of the TC tables that should have been installed (TC_xxxxx).

Image removed by sender.

If these are installed correctly, then when you login to that database and go to the TC Configuration window as your normal user, it should tell you that all the settings are read-only, because
you don’t have the Admin role. In your case, it’s saying it’s not installed, so I would verify that your install worked correctly.

Image removed by sender.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Image removed by sender.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Image removed by sender.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Image removed by sender.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#10

I see you’re using an un-patched release of Toad. This may or may not make a difference with this particular issue but you should upgrade if you can.

You’re on 12.1.0. 12.1.1 patch should be available on support link.

We test Team Coding using a non-Toad schema every release, but we test with a schema that has the DBA role. I just checked the Toad documentation (F1 and search
for “Team Coding Setup”) and it states that the schema where the TC objects are installed is required to have DBA privileges

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 10:03 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Yes, it has the role:

SQL> select * from user_role_privs;

USERNAME GRANTED_ROLE ADM DEF OS_


#11

As a DBA myself for the past 15 or so years (eep!), I have to say that I don’t understand the “_OWNER” suffix requirement. Would that also be a requirement of SAP or other COTS software that uses Oracle? I’d hope that answer would be a “no”.
If it’s for grouping/organization purposes, there are profiles (or even roles) for that. But I have a feeling that changing that policy in order to get one feature of one development product working is going to be met with resistance.

Us DBAs should must have complete control over the structure of the database – that’s one of the reasons we exist. But even as I’ve been unsuccessful in dropping the alias of a WWII German soldier from my title where I work, there comes a point at which we need to evaluate our ability to be flexible enough to handle the business requirements of our internal IT customers, while still maintaining the security and integrity of the precious data assets of our respective businesses.

Why yes, it does feel like a Friday today… Good luck, Vince!

Rich


#12

Brad,

That is both the most informative and most discouraging information yet on this problem! L

Can you be specific as to what is meant by “DBA privileges?” Is that a role that TOAD_OWNER user may be granted? More helpful, can you explain what specifically
requires the DBA privileges – a real-time check on the server, an assumed privilege that might break once Team Coding is in use, etc.

For me, the key would be what tells the TOAD front end that the required server side objects have not been installed? I thought there was a way I could monitor
TOAD’s sql as I perform client operations – can I use that to determine the queries that cause TOAD to believe the objects are not installed?

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Thursday, July 02, 2015 10:11 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Brad Boddicker

I see you’re using an un-patched release of Toad. This may or may not make a difference with this particular issue but you should upgrade if you can.

You’re on 12.1.0. 12.1.1 patch should be available on support link.

We test Team Coding using a non-Toad schema every release, but we test with a schema that has the DBA role. I just checked the Toad documentation (F1 and search
for “Team Coding Setup”) and it states that the schema where the TC objects are installed is required to have DBA privileges

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 10:03 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Yes, it has the role:

SQL> select * from user_role_privs;

USERNAME GRANTED_ROLE ADM DEF OS_

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#13

RichJ,

Oh, this is not the half of it. If you heard some of the restrictions we live under… you’d understand at lot less. In the last month or so they completely blocked GitHub … and seem to ignore the loud cries of just how many things broke as a result.

As one person put it, the “Productivity Containment Initiative” is alive and well where I work.

Vince


#14

I can’t really speak as to why the DBA role is required. A developer would have to address this question.

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 10:27 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Brad,

That is both the most informative and most discouraging information yet on this problem! L

Can you be specific as to what is meant by “DBA privileges?” Is that a role that TOAD_OWNER user may be granted? More helpful, can you explain what specifically
requires the DBA privileges – a real-time check on the server, an assumed privilege that might break once Team Coding is in use, etc.

For me, the key would be what tells the TOAD front end that the required server side objects have not been installed? I thought there was a way I could monitor
TOAD’s sql as I perform client operations – can I use that to determine the queries that cause TOAD to believe the objects are not installed?

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Thursday, July 02, 2015 10:11 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Brad Boddicker

I see you’re using an un-patched release of Toad. This may or may not make a difference with this particular issue but you should upgrade if you can.

You’re on 12.1.0. 12.1.1 patch should be available on support link.

We test Team Coding using a non-Toad schema every release, but we test with a schema that has the DBA role. I just checked the Toad documentation (F1 and search
for “Team Coding Setup”) and it states that the schema where the TC objects are installed is required to have DBA privileges

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 10:03 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Yes, it has the role:

SQL> select * from user_role_privs;

USERNAME GRANTED_ROLE ADM DEF OS_

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#15

I just found that message in the source code that says “A DBA Session is required to install Team Coding Objects”.

I don’t know why these specific checks are made (my guess is that in fact they really aren’t needed at all), but any of these will get you past that message.

The user has the ALTER DATABASE and ALTER SYSTEM system privileges

Or

The user has the SYSDBA privilege (not necessarily that you are logged in that way)

Or

You are logged in as TOAD (which seems like a bug, seems like it ought to be checking that you are logged in as the schema that you installed Team Coding into,
but that’s what the code says…)

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 9:27 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Brad,

That is both the most informative and most discouraging information yet on this problem! L

Can you be specific as to what is meant by “DBA privileges?” Is that a role that TOAD_OWNER user may be granted? More helpful, can you explain what specifically
requires the DBA privileges – a real-time check on the server, an assumed privilege that might break once Team Coding is in use, etc.

For me, the key would be what tells the TOAD front end that the required server side objects have not been installed? I thought there was a way I could monitor
TOAD’s sql as I perform client operations – can I use that to determine the queries that cause TOAD to believe the objects are not installed?

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Thursday, July 02, 2015 10:11 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by Brad Boddicker

I see you’re using an un-patched release of Toad. This may or may not make a difference with this particular issue but you should upgrade if you can.

You’re on 12.1.0. 12.1.1 patch should be available on support link.

We test Team Coding using a non-Toad schema every release, but we test with a schema that has the DBA role. I just checked the Toad documentation (F1 and search
for “Team Coding Setup”) and it states that the schema where the TC objects are installed is required to have DBA privileges

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 10:03 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

Yes, it has the role:

SQL> select * from user_role_privs;

USERNAME GRANTED_ROLE ADM DEF OS_

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#16

John,

Pure gold! Thanks for checking that out.

*The user has the ALTER DATABASE and ALTER SYSTEM system privileges *- Not going to happen in my world
L

The user has the SYSDBA privilege (not necessarily that you are logged in that way)

  • Definitely not happening L
  • You are logged in as TOAD (which seems like a bug, seems like it ought to be checking that you are logged in as the schema that you installed Team Coding
    into, but that’s what the code says…) –*

Not happening without a fight, but since you have determined the code requires that specific user name, I can use that as leverage with the powers that be.
Let me try that angle.

Thanks for checking the source for this issue.

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 02, 2015 10:42 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by John Dorlon

I just found that message in the source code that says “A DBA Session is required to install Team Coding Objects”.

I don’t know why these specific checks are made (my guess is that in fact they really aren’t needed at all), but any of these will get you past that message.

The user has the ALTER DATABASE and ALTER SYSTEM system privileges

Or

The user has the SYSDBA privilege (not necessarily that you are logged in that way)

Or

You are logged in as TOAD (which seems like a bug, seems like it ought to be checking that you are logged in as the schema that you installed Team Coding into,
but that’s what the code says…)


#17

Let me see if I can come up with a script that you can run to create the required objects. I’ll get back to you shortly.

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 9:49 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

John,

Pure gold! Thanks for checking that out.

*The user has the ALTER DATABASE and ALTER SYSTEM system privileges *- Not going to happen in my world
L

The user has the SYSDBA privilege (not necessarily that you are logged in that way)

  • Definitely not happening L
  • You are logged in as TOAD (which seems like a bug, seems like it ought to be checking that you are logged in as the schema that you installed Team Coding
    into, but that’s what the code says…) –*

Not happening without a fight, but since you have determined the code requires that specific user name, I can use that as leverage with the powers that be.
Let me try that angle.

Thanks for checking the source for this issue.

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 02, 2015 10:42 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by John Dorlon

I just found that message in the source code that says “A DBA Session is required to install Team Coding Objects”.

I don’t know why these specific checks are made (my guess is that in fact they really aren’t needed at all), but any of these will get you past that message.

The user has the ALTER DATABASE and ALTER SYSTEM system privileges

Or

The user has the SYSDBA privilege (not necessarily that you are logged in that way)

Or

You are logged in as TOAD (which seems like a bug, seems like it ought to be checking that you are logged in as the schema that you installed Team Coding into,
but that’s what the code says…)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#18

OK, the attached script is what I captured from Toad 12.1 as it set up Team Coding into the TOAD schema. So you’ll want to do a search and replace for “TOAD”
and replace it with “TOAD_OWNER”

Just don’t replace it in the values of this statement.

INSERT INTO TOAD.tc_config

        (script_ext, vcs_vcp_name, frozen, version)

 VALUES ('*.sql;', -1, 'N', '0070TOAD08000000');

It also creates the TOAD user and TC_ADMIN_ROLE.

This *should * work, but just so we’re clear – you aren’t getting this through an official support channel, so I can’t make any promises. But I think
you’ll know pretty quickly if it works or not…

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 02, 2015 9:54 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by John Dorlon

Let me see if I can come up with a script that you can run to create the required objects. I’ll get back to you shortly.

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 9:49 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

John,

Pure gold! Thanks for checking that out.

*The user has the ALTER DATABASE and ALTER SYSTEM system privileges *- Not going to happen in my world
L

The user has the SYSDBA privilege (not necessarily that you are logged in that way)

  • Definitely not happening L
  • You are logged in as TOAD (which seems like a bug, seems like it ought to be checking that you are logged in as the schema that you installed Team Coding
    into, but that’s what the code says…) –*

Not happening without a fight, but since you have determined the code requires that specific user name, I can use that as leverage with the powers that be.
Let me try that angle.

Thanks for checking the source for this issue.

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 02, 2015 10:42 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by John Dorlon

I just found that message in the source code that says “A DBA Session is required to install Team Coding Objects”.

I don’t know why these specific checks are made (my guess is that in fact they really aren’t needed at all), but any of these will get you past that message.

The user has the ALTER DATABASE and ALTER SYSTEM system privileges

Or

The user has the SYSDBA privilege (not necessarily that you are logged in that way)

Or

You are logged in as TOAD (which seems like a bug, seems like it ought to be checking that you are logged in as the schema that you installed Team Coding into,
but that’s what the code says…)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#19

John,

Let me start by saying how impressed I am that you would invest this time for me. Really, thanks, and I will recommend your product and support staff as a
result.

Since I cannot run the create TOAD user portion, I had our DBA do that previously (as TOAD_OWNER not TOAD). However, standards did not permit the use of the
“ANY” modifier in these two statements:

GRANT SELECT ANY DICTIONARY TO TOAD;

GRANT CREATE ANY TRIGGER TO TOAD;

Also the following statement could not be run due to policy:

GRANT CREATE ROLE TO TOAD;

The rest of the script as you have it was run without errors. The TC_ADMIN_ROLE was created directly by the DBA and granted to TOAD_OWNER.

Here is what I see for TOAD_OWNER’s script:

SET
DEFINE
OFF;

– TOAD_OWNER (User)

CREATE
USER TOAD_OWNER

IDENTIFIED
BY

DEFAULT
TABLESPACE TOAD_DATA01

TEMPORARY
TABLESPACE
TEMP

PROFILE DB_SCHEMA_OWNER_PROFILE

ACCOUNT
UNLOCK;

– 4 Roles for TOAD_OWNER

GRANT
DB_CATALOG_ROLEV11203 TO TOAD_OWNER;

GRANT DB_CONNECT
TO TOAD_OWNER;

GRANT TC_ADMIN_ROLE
TO TOAD_OWNER
WITH
ADMIN
OPTION;

GRANT TOAD_OWNER_ROLE
TO TOAD_OWNER;

ALTER
USER TOAD_OWNER
DEFAULT
ROLE TC_ADMIN_ROLE;

Attached are the roles granted to TOAD_OWNER.

But, since the checks you mentioned are for TOAD user and not for TOAD_OWNER, isn’t this all moot?
I am attempting to get a TOAD schema created so that the checks you mentioned will be satisfied.

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 02, 2015 11:23 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by John Dorlon

OK, the attached script is what I captured from Toad 12.1 as it set up Team Coding into the TOAD schema. So you’ll want to do a search and replace for “TOAD”
and replace it with “TOAD_OWNER”

Just don’t replace it in the values of this statement.

INSERT INTO TOAD.tc_config

        (script_ext, vcs_vcp_name, frozen, version)

 VALUES ('*.sql;', -1, 'N', '0070TOAD08000000');

It also creates the TOAD user and TC_ADMIN_ROLE.

This *should * work, but just so we’re clear – you aren’t getting this through an official support channel, so I can’t make any promises. But I think
you’ll know pretty quickly if it works or not…

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 02, 2015 9:54 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by John Dorlon

Let me see if I can come up with a script that you can run to create the required objects. I’ll get back to you shortly.

From: DbVince [mailto:bounce-DbVince@toadworld.com]

Sent: Thursday, July 02, 2015 9:49 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by DbVince

John,

Pure gold! Thanks for checking that out.

*The user has the ALTER DATABASE and ALTER SYSTEM system privileges *- Not going to happen in my world
L

The user has the SYSDBA privilege (not necessarily that you are logged in that way)

  • Definitely not happening L
  • You are logged in as TOAD (which seems like a bug, seems like it ought to be checking that you are logged in as the schema that you installed Team Coding
    into, but that’s what the code says…) –*

Not happening without a fight, but since you have determined the code requires that specific user name, I can use that as leverage with the powers that be.
Let me try that angle.

Thanks for checking the source for this issue.

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Thursday, July 02, 2015 10:42 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Enable Team Coding when can’t use DBA connection

RE: Enable Team Coding when can’t use DBA connection

Reply by John Dorlon

I just found that message in the source code that says “A DBA Session is required to install Team Coding Objects”.

I don’t know why these specific checks are made (my guess is that in fact they really aren’t needed at all), but any of these will get you past that message.

The user has the ALTER DATABASE and ALTER SYSTEM system privileges

Or

The user has the SYSDBA privilege (not necessarily that you are logged in that way)

Or

You are logged in as TOAD (which seems like a bug, seems like it ought to be checking that you are logged in as the schema that you installed Team Coding into,
but that’s what the code says…)

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#20

I think you’ll be fine without SELECT ANY DICTIONARY. That’s for other things that can be installed into the TOAD schema. I’m not even sure what CREATE ANY TRIGGER is doing in there. It probably ought to be just CREATE TRIGGER. But once the objects are there, you’ll be fine without it. Same with CREATE ROLE.

But, since the checks you mentioned are for TOAD user and not for TOAD_OWNER, isn’t this all moot?

Right. I think once all those tables, triggers and indexes are created using that script I gave you (as well as the public synonym and grants to public and tc_admin_role at the end of the script), Toad will act like Team Coding is already installed.