Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> some sys tables available to all users?
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
![]() |
![]() |