Re: read only user please help someone

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 27 Mar 2006 08:34:30 -0800
Message-ID: <1143477270.884515.274880@z34g2000cwc.googlegroups.com>

Mangood, all users will have all privileges granted on any object granted to PUBLIC, but other than that users have only those privileges either direcly granted to them or to the roles granted to them.

drop the user.
re-create the user.
grant create session to the user

Log on as the user. The user should not have access to any object not granted to public. If you find the user has privileges that you have not granted then check your database for the presence of database event triggers. Look for one trigger on DDL for create user and on logon. You could be automatically granting every newly created id certain privileges via the triggers.

HTH -- Mark D Powell -- Received on Mon Mar 27 2006 - 10:34:30 CST