Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: grants

Re: grants

From: N3Gro <leo.mendez_at_terra.cl>
Date: Mon, 29 Jul 2002 10:41:16 -0400
Message-ID: <3d455599$1@omega>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US