Is that the only option left? Does it mean that we cant specify the privileges at user level in oracle. There is no role called OPERATOR too. I want my managers to see the information only. Any other way out? Regards - Chirag On 8/27/05, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote: > > Hi > > >I want to create a user who can only SEE through oem browser. > >I found one role called oem_monitor, I assigned that to a user but > >unable to login to browser oem through that user. > > > >create user chirag identified by chirag; > >grant connect,create session to chirag; > >grant oem_monitor to chirag; > >OR > >grant select any dictinary to chirag; > > AFAIK a "minimal" user should have SELECT ANY DICTIONARY and the role > MGMT_USER. > You should be able to let create such a user under Setup->Administrators. > > >If I m trying to create a view only user through OEM, it still gives a > >user to STARTUP - SHUTDOWN options on the database. > > For a startup/shutdown, IIRC, a user should enter the credentials for host > and database (except if you defined preferred credentials...). Therefore if > a user doesn't know such information (s)he should not be able to (re)start a > database. > > > HTH > Chris > > New Features Oracle Database 10g Release 2 seminars @ > www.trivadis.com<http://www.trivadis.com> > Italiano: Lugano (24-Nov) > Français: Genève (17-Nov) > Deutsch: Zürich (11-Oct), Hamburg (13-Oct), München (20-Oct), Basel > (25-Oct), > Frankfurt (27-Oct), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart (13-Dec) >