Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: USER_TABLES
No you can't. USER_TABLES is a dictionary view owned by SYS that selects the
tables of the current connected user. There is no "USER_TABLES" in Fred's
schema.
Instead query ALL_TABLES where owner='FRED'. This will show all tables in Fred's schema you have access to, so not necessarily all tables of Fred.
If that's not what you want, query DBA_TABLES, it shows all tables that exist in the database, but you must have sufficient privileges to query this view, like DBA role or (more restrictive) SELECT_CATALOG_ROLE.
Read Oracle8i Reference Manual to get familiar with the dictionary views from your documentation CD or on tahiti.oracle.com where all Oracle books can be found online.
Brian Everett <brian.everett01_at_removeherecomcast.net> schreef in
berichtnieuws 49masukg77mkht9pjceq5t41mq6klvcuji_at_4ax.com...
|
| In a procedure I need to have a list of tables from another schema.
| Can I be given rights to view someone else's USER views?
|
| If I am in Bob schema and I want to see a list of tables owned by Fred
| in his schema could
| I look at SELECT TABLE_NAMES FROM FRED.USER_TABLES with the correct
| grant ?
|
| Currently, if I am Bob I can do a DESC FRED.USER_TABLES and get a
| proper return.
|
| Note: I need this question answered. I don't require an alternative.
|
| Thanks,
|
| Brian
|
Received on Sun Nov 03 2002 - 11:58:17 CST