Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: read only user please help someone
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
![]() |
![]() |