jejejejej
A lot of thanks
"Richard Foote" <richard.foote_at_bigpond.com> escribió en el mensaje
news:Xs019.46357$Hj3.140904_at_newsfeeds.bigpond.com...
> 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 Mon Jul 29 2002 - 09:41:16 CDT
