Restricting Schema access/visibility

From: D Huynh <remove.duchuynh_at_pacbell.net>
Date: Thu, 24 Dec 1998 16:16:11 -0800
Message-ID: <QMAg2.2459$G92.9467@typhoon-sf.snfc21.pbi.net>

I created a user, ABC with 'Connect' and 'Resources' roles. I then log in under ABC and create 2 tables, T1 and T2. If I do a

SELECT TABLE_NAME FROM USER_TABLES I get back a bunch of tables others than T1 and T2 (e.g. EVT_REGISTRY, SMRELEASE_S,...) I notice that if I log in to the Schema manager, I also see the other predefined schema, such as DEMO.

All this come from a fresh installation of 8.0.4. How do I restrict user/schema ABC so that when ABC logs in, all the ables that he can see are T1 and T2?

TIA. Received on Thu Dec 24 1998 - 18:16:11 CST