-
Account for all tables in SQL Plus?
I am just learning Oracle 9i and SQL Plus. After going through
setting up everything and examining the starter database I have found
that SQL Plus will not allow me to everything in the database.
Example: If I log in using Sys/password I can see system related
tables but I cant query on the example schemas that were installed.
If I log in as Scott/tiger I can see that schema and tables.
Is there an account that will allow me to see everyone's schema setup
and also query on it?
I would like to log on once in a non administrator account and be
able to query on any table in any schema including some of the
system views.
I am working on my Applications Developer cert and really need to know
the workings of tables and schema for development purposes.
Any help would be appreciated. Thanks JW
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|