Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: read only user please help someone

Re: read only user please help someone

From: Mark D Powell <Mark.Powell_at_eds-dot-com.no-spam.invalid>
Date: 28 Mar 2006 06:29:39 GMT
Message-ID: <4428d7d2$0$16324$892e7fe2@authen.yellow.readfreenews.net>


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 Tue Mar 28 2006 - 00:29:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US