Re: Trigger AND CREATE USER (dynamic SQL)

From: Jean-Claude Matarazzo <jcmata_at_free.fr>
Date: Sat, 13 Jan 2001 19:12:28 GMT
Message-ID: <wM186.29$QM.116851@nnrp5.proxad.net>

Hello,

When the trigger runs, inside the trigger, you can not do a commit or a rollback.
And the CREATE USER or CREATE TABLE or DROP USER, DROP TABLE , ...does a commit *automatic*.
So you can not use the CREATE, DROP, GRANT, REVOKE, ALTER,...

Regards

"Manuel" <manuelbaena_at_airtel.net> a écrit dans le message news: 3A605F55.EB4BDC09_at_airtel.net...
> I'm use Oracle 8.
> I need create a new user when a trigger run.
> Can someone help me?
>
> RE to:
> manuelbaena_at_airtel.net
>
>
Received on Sat Jan 13 2001 - 13:12:28 CST