Fwd: VCS - Team Coding

Toad for Oracle & DevOps Toolkit
1

SEE ATTACHMENT

att1.dat (43 Bytes)
att1.dat (13.2 KB)

2

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.
image002.png

3

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.
image001.png

4

Matt beat me to the punch J

11.5 has added an additional check for SYS users. Also make sure that the Read
Only option is not set in the connection. That has caught me on a number of
occasions.
image001.png

5

Matt beat me to the punch J

11.5 has added an additional check for SYS users. Also make sure that the Read
Only option is not set in the connection. That has caught me on a number of
occasions.
image002.png

6

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
image002.png

7

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
image001.png

8

SEE ATTACHMENT
moz-screenshot-9.png

9

SEE ATTACHMENT
moz-screenshot-8.png

10

SEE ATTACHMENT
att1.dat (6.99 KB)

11

SEE ATTACHMENT
att1.dat (13.2 KB)

12

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
image001.png

13

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
moz-screenshot-9.png

14

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
image002.png

15

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
moz-screenshot-8.png