# toad connectivity

**URL:** <https://forums.toadworld.com/t/toad-connectivity/10479>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 25, 2011, 3:04am UTC](https://forums.toadworld.com/t/toad-connectivity/10479 "2011-05-25T03:04:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sonimiteshk\_921](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@sonimiteshk\_921](https://forums.toadworld.com/u/sonimiteshk_921)\
**Post date:** [May 25, 2011, 3:04am UTC](https://forums.toadworld.com/t/toad-connectivity/10479/1 "2011-05-25T03:04:42Z")

</div>

Hello All,  
If i connect toad with oracle by using username/password,  
will it connect to all the schemas by default or to the particular schema only?

by using schema instead of username/pass it connects to a schema only,  
please provide some basic toad learning link as well.

Thanks

---

<div class="post-metadata">

**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\
**Post date:** [May 25, 2011, 3:19am UTC](https://forums.toadworld.com/t/toad-connectivity/10479/2 "2011-05-25T03:19:21Z")

</div>

Morning sonimiteshk\_921,

> If i connect toad with oracle by using username/password,  
> will it connect to all the schemas by default or to the particular  
> schema only?  
> If you connect with Toad to the user scott with password pussycat on  
> database mydb, then you will connect specifically to the scott schema.

Depending on what privileges the scott user has been granted, by other  
schemas and/or by the sys/system schemas, then you may well be able to  
see data and code belonging to those other users.

> by using schema instead of username/pass it connects to a schema only,  
> ?????

> please provide some basic toad learning link as well.  
> Try looking in the \doc folder where Toad is installed. Then there's  
> [www.asktoad.com](http://www.asktoad.com) and [www.toadworld.com](http://www.toadworld.com). Coming soon is a new all in one  
> place Toad community, but it's not up and running yet. Watch this list  
> for details.

--  
Cheers,  
Norm. [TeamT]
