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.
