Re: alter user via dbms_sql

> Yes.
>
> Alan Shein wrote in message <7soaml$9uq$1_at_winter.news.rcn.net>...
> >Did you GRANT EXECUTE on the procedure to the user who needs to run it?

I found out, that Oracle 7.3.4 has problems with rights granted over a role to a user.
System priviliges (like 'create table') have to be granted directly to the user,
who wants to use it within a procedure.

Try 'grant alter user to <user>' before running the dbms_sql-command within a procedure

Regards, Stephan
--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------