Oracle Database Discussions

Hi.
Oracle Version: 9.2.0.6
OS: Sun solaris 8

I have a database with:
O7_DICTIONARY_ACCESSIBILITY boolean FALSE

I create a new user:
create user lala identified by lala

grant create session to lala

Then i log on the user and check his privileges:
select * from user_sys_privs;

LALA|CREATE SESSION|NO

But, from the user i can do:
select * from all_tables;

and it shows sys tables as well system,wksys,etc,etc.

I checked that public have select any table privilege:
select owner,table_name,grantor,grantee, privilege from dba_tab_privs where grantee='PUBLIC' and table_name = 'ALL_TABLES'

SYS|ALL_TABLES|SYS|PUBLIC|SELECT

then i tried (as sysdba):
revoke select any table from public
but
ORA-01952: system privileges not granted to 'PUBLIC'

I had read that O7_DICTIONARY_ACCESSIBILITY at false wont show sys tables, and it does atm. Also i dont want that users have select all tables privileges via public, but i cant revoke privilege.
Can someone help me showing what im doing bad?
Thanks for all

Edited by: Ricard on Jun 10, 2009 9:40 AM