Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> some sys tables available to all users?

some sys tables available to all users?

From: Verna Legaspi <vlegaspi_at_uswest.net>
Date: 2000/07/20
Message-ID: <hVMd5.914$WU5.220726@news.uswest.net>#1/1

Hello,

I created a new user which I intend to only have SELECT privs on a view of a table on another schema. I then just granted this user create session and select to the view. However, when I do a SELECT owner, table_name
  FROM all_tables;

I see more than I expected to. As this supposedly limited user, I can do selects on sys.system_privilege_map, sys.audit_actions, etc. I also use TOAD and notice this user can also see some of the TOAD user's tables such as toad_plan_table.

Is this normal? Is this safe?

TIA,
Verna Received on Thu Jul 20 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US