Re: 10g oem privs
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 15:00:07 -0400
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)
>
Other related posts: