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_at_trivadis.com> 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)
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 31 2005 - 14:02:07 CDT
