--- Ivan Prenosil <Ivan.Prenosil@...> wrote:

> > How can I grant a right to create trigger on a
> table to a user ?
> >
> > I get this error :
> > unsuccessful metadata update
> > -DEFINE TRIGGER failed
> > -no permission for control access to TABLE
> CURRINSP
> >
> > Tried "grant all" but it does not work.
>
> You can't. Only table owner and SYSDBA have rights
> to create triggers.
>

Ivan, thanks for the reply.

Then, is there any way for my to transfer the
ownership of a table to somebody else ?

Thanks,

Vu






__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail