# TYPES

**URL:** <https://forums.toadworld.com/t/types/33900>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [August 9, 2015, 2:34am UTC](https://forums.toadworld.com/t/types/33900 "2015-08-09T02:34:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wilko.helms\_796](https://avatars.discourse-cdn.com/v4/letter/w/ed8c4c/32.png) [@wilko.helms\_796](https://forums.toadworld.com/u/wilko.helms_796)\
**Post date:** [August 9, 2015, 2:34am UTC](https://forums.toadworld.com/t/types/33900/1 "2015-08-09T02:34:34Z")

</div>

Toad will not show types owned by specific schema. It only shows types owned by sys. Seems to depend on having synonyms on types. Oracle gets synonyms for types without any problem.

I’m using toad 12.1 64 bit under windows7, oracle 12.1 under suse linux.

Does anybody know this as a toad bug?

thanks for help

Wilko

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [August 10, 2015, 5:40am UTC](https://forums.toadworld.com/t/types/33900/2 "2015-08-10T05:40:43Z")

</div>

If you log in as the owner of the types, Toad will select from USER\_TYPES and USER\_OBJECTS. If you want to see types from a different schema, Toad users DBA\_TYPES and DBA\_OBJECTS if you have privileges to select from them (sounds like you don’t), otherwise ALL\_TYPES and ALL\_OBJECTS.

The ALL\_ views only show objects that you have privileges on, so maybe that is the problem.
