Hello Guru's

I created a user and granted 'SELECT ' (which should be read only) on one
table.

CREATE USER <xxxx> PROFILE DEFAULT IDENTIFIED BY <xxxx>
DEFAULT TABLESPACE <xxxx> TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON <xxxx> ACCOUNT UNLOCK;

GRANT CREATE SESSION TO <xxxx>
GRANT UNLIMITED TABLESPACE TO <xxxx>
GRANT SELECT ON <xxxx>.<xxxx> TO <xxxx>;

My question is - Why can this user see the following SYS & SYSTEM, & how
can I revoke that?

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
SYSTEM DEF$_TEMP$LOB
SYSTEM HELP
SYS PLAN_TABLE$
SYS IMPDP_STATS
SYS KU$NOEXP_TAB
SYSTEM OL$NODES

OWNER TABLE_NAME
------------------------------ ------------------------------
SYSTEM OL$HINTS
SYSTEM OL$
SYS ODCI_WARNINGS$
SYS ODCI_SECOBJ$
SYS WRI$_ADV_ASA_RECO_DATA
SYS PSTUBTBL

17 rows selected.



Thanks much!
Greg
U.S. BANCORP made the following annotations
---------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.



---------------------------------------------------------------------


Oracle LazyDBA home page