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: lock table

Re: lock table

From: Andrew Clark <lark047_at_gmail.com>
Date: 2 Jun 2006 06:02:09 -0700
Message-ID: <1149253329.430228.211280@h76g2000cwa.googlegroups.com>


Actually, it's my error. I do not seem to have the necessary privileges. From user_tab_privs I can't see any privileges on that table. I was told the DBA did the grants for me, but I guess not!

Thanks,
Andrew

bdbafh_at_gmail.com wrote:
> lark047_at_gmail.com wrote:
> > Hi,
> >
> > I am confused why I can't lock a particular table. The table is not in
> > my schema, but I do have some object privileges on it (insert, delete).
> > Everything I've seen says that's all I need:
> >
> > One of 3
> > - LOCK ANY TABLE
> > - owner of table
> > - object privileges on table
> >
> > Help?
> >
> > Andrew
>
> what is the statement that you are attempting to execute? (include it)
> what is the error message? (include it)
> what version of oracle? (include it).
>
> -bdbafh
Received on Fri Jun 02 2006 - 08:02:09 CDT

Original text of this message

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