Some of the tables have been granted to public, so all the users in the
database will be able to see them.
Tom
Verna Legaspi <vlegaspi_at_uswest.net> wrote in message
news:hVMd5.914$WU5.220726_at_news.uswest.net...
> 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 Fri Jul 21 2000 - 00:00:00 CDT
