Toad World® Forums

Fwd: VCS - Team Coding

SEE ATTACHMENT

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

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

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

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

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

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

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

SEE ATTACHMENT
moz-screenshot-9.png

SEE ATTACHMENT
moz-screenshot-8.png

SEE ATTACHMENT
att1.dat (6.99 KB)

SEE ATTACHMENT
att1.dat (13.2 KB)

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

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

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

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