Re: grants

Hi C3PO, ooppps sorry, I mean N3Gro

OK, check the following:

1. Confirm this user definitely has the Update Any Table privilege (check in dba_sys_privs). If not, grant again and retry, else
2. Confirm this user is definitely the user connected (show user command or select username from user_users). If not, connect as correct user and retry, else
3. Confirm the table to be updated definitely exists in the correct schema (select owner and table_name from dba_tables). Else,
4. Ensure the correct table is being referenced in the update (use owner prefix.tablename, recheck tablename is correct). Else,
5. Supply the error message (ORA-10031: insufficient privileges ?) you get when attempting the update because I'm now curious ...

Regards

Richard

"N3Gro" <leo.mendez_at_terra.cl> wrote in message news:3d408712$1_at_omega...
> No men , he's at his own schema
> Thanks
>
> "Richard Foote" <richard.foote_at_bigpond.com> escribió en el mensaje
> news:q7M%8.43409$Hj3.131054_at_newsfeeds.bigpond.com...
> > Hi N3Gro,
> >
> > The user isn't by any chance trying to update a table that belongs to
SYS
> ?
> >
> > Regards
> >
> > Richard
> > "N3Gro" <leo.mendez_at_terra.cl> wrote in message news:3d3f435f$1_at_omega...
> > > Hi everybody
> > > Anybody knows why if a run this script Nothing happends:
> > >
> > > GRANT SELECT ANY TABLE,INSERT ANY TABLE,UPDATE ANY TABLE
> > >
> > > TO USER
> > >
> > > WITH ADMIN OPTION;
> > >
> > >
> > >
> > > the user after this modification still without the rigths to update ,
> > >
> > > but to select and insert there's no problem
> > >
> > > Thanks in advanced
> > >
> > > Leo
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Sun Jul 28 2002 - 20:08:30 CDT