Re: I only want to see five tables with an Oracle user ID?

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:aa5cp0$cs1$1_at_lust.ihug.co.nz...
> So the problem is (again, I'm only assuming the original poster meant
this)
> that the list of tables etc. is collated *before* any privileges or
> user-specific issues are checked on.

This certainly appears to be the case. I've also just checked using officeXP and the oledb providers and one gets the same 'problem'. I think the answer is related to the output below though (9i eg). It isn't quite as simple as that though as one also gets some but not all of the views available through the all_views view.

SQL> create user u2 identified by u2;

User created.

SQL> grant create session to u2;

Grant succeeded.

SQL> connect u2/u2
Connected.
SQL> select owner,table_name from all_tables;

OWNER                          TABLE_NAME
------------------------------ ------------------------------
SYS                            DUAL
SYS                            SYSTEM_PRIVILEGE_MAP
SYS                            TABLE_PRIVILEGE_MAP
SYS                            STMT_AUDIT_OPTION_MAP
SYS                            AUDIT_ACTIONS
SYS                            PSTUBTBL
SYSTEM                         DEF$_TEMP$LOB
SYS                            ODCI_SECOBJ$
SYS                            ODCI_WARNINGS$
SYSTEM                         HELP
MDSYS                          OGIS_SPATIAL_REFERENCE_SYSTEMS

OWNER                          TABLE_NAME
------------------------------ ------------------------------
MDSYS                          USER_CS_SRS
MDSYS                          USER_TRANSFORM_MAP
MDSYS                          SDO_DIST_UNITS
MDSYS                          SDO_AREA_UNITS
MDSYS                          SDO_ANGLE_UNITS
MDSYS                          CS_SRS
MDSYS                          SDO_ELLIPSOIDS
MDSYS                          SDO_PROJECTIONS
MDSYS                          SDO_DATUMS
WKSYS                          WK$SYS_ADMIN
WKSYS                          WK$DATA_SOURCE

OWNER                          TABLE_NAME
------------------------------ ------------------------------
WKSYS                          WK$TDS_LOG
WKSYS                          WK$SOURCE_GROUP
WKSYS                          WK$GROUP_DS_MAPPING
WKSYS                          WK$JOB_INFO
WKSYS                          WK$CRAWLER_SCHED
WKSYS                          WK$SCHED_MAPPING
WKSYS                          WK$CRAWLER_CONFIG
WKSYS                          WK$CRAWLER_CONFIG_DEFAULT
WKSYS                          WK$TRACE
WKSYS                          WK$ATTRIBUTE
WKSYS                          WK$ATTR_MAPPING

OWNER                          TABLE_NAME
------------------------------ ------------------------------
WKSYS                          WK$MIMETYPES
WKSYS                          WK$CHARSET
WKSYS                          WK$LANG
WKSYS                          WK$MAILLIST
WKSYS                          WK$CRAWLER_STAT
OLAPSYS                        OS_CHILD_INSTANCES
OLAPSYS                        OS_OSA_PRIVILEGES

40 rows selected. Received on Wed Apr 24 2002 - 04:46:51 CDT