Toad World® Forums

How to display ALL tables on the left in schema browser?


#1

I logged into a database with user SYSTEM.
Unfortuantely in Schema Browser on the left side there are only the TABLEs
of SYSTEM (=owner) are listed.

Filter = *

How can I list ALL TABLEs from all users on the left side?

Ben

View this message in context: http://old.nabble.com/How-to-display-ALL-tables-on-the-left-in-schema-browser--tp27674955p27674955.html
Sent from the TOAD mailing list archive at Nabble.com.


#2

In the Schema Browser, left hand side, press the Filter button (just above the list of table names). In the Schema Browser Filters window, under Name Filters->Schema Name select All Schema or All Except SYS.

Richard


#3

Why are you logging on as SYSTEM?

You’d be better off logging on as SYS, and then only if you need to apply
a patch or shutdown the database.


#4

Just to reiterate something about the built in Oracle accounts:

SYSTEM is a sample DBA account with some of the more common DBA rights already
granted to it – but not all of them. In fact, it’s missing a bunch.
But it’s meant to demonstrate the kind of accounts one should create. The
recommendation is that people create a DBA role or template of rights and then
grant that to the DBA schemas or users they create. That SYSTEM is just an
example to let you hit the ground running in a proper fashion – but not
with all a good DBA will need.

SYS is the magic account much like root on unix/linux and administrator on
windows. You should only connect to the database as SYS rarely – for tasks
that strictly require SYS access in order to function. Examples include Oracle
patches, upgrades, certain startup/shutdown/back/recovery options and some
scripts run to add additional functions the database – e.g. stats pack
table and package creation.

As such, I would not expect people to have a toad connection defined for SYS
– since they should only be using this rarely and for very isolated tasks
– and not for general use.