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

lark047@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

bdbafh@gmail.com wrote:
> lark047@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

Why are you trying to lock a table to begin with? The lock table
commands should only be used in certain processing situations. Every
DML statement will acquire the row level locks and object enqueues that
it needs.

The information bdbafh requested should be in most every post.

HTH -- Mark D Powell --

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@gmail.com wrote:
> lark047@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

Mark D Powell wrote:
> The information bdbafh requested should be in most every post.
>
> HTH -- Mark D Powell --
>

Together with SSN, valid credit card number and expiry date. He is,
after all, Bastard DBA From Hell.

--
Mladen Gogala
http://www.mgogala.com