Re: The Application requires more database privileges

I have to grant select only access for schemas BTEST and DTEST for user Mtom.

I created user Mtom.

select 'GRANT '||'SELECT ON '||owner||'.'||object_name||' TO Mtom;' from all_objects
where owner in ('BTEST' , 'DTEST'); (BTEST & DTEST are schemas)

Then I granted connect to Mtom;

When I as a user Mtom tries to login thru OEM I am getteing an error stating:
This application requires more database privileges than you have currently been granted.

using oracle 10.1.0.4.0

DA Morgan wrote:
> muddu wrote:
> > hi,
> >
> > I have created an user and granted select privileges to access two
> > schemas.
> > When I try to login as user using OEM I am getting the error :
> > This application requires more database privilges than you have
> > currently been granted.
> > I am using Oracle 10.1.0.4.0 enterprise edition.
> >
> > Thanks in Advance.
>
> OEM does.
>
> It is far from clear what you did from "granted select privileges."
> What privilege(s) did you actually grant and on what?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Sat Oct 21 2006 - 16:15:35 CDT