Re: How can i lock an user from a package?

Thanks, it works :-)

I had a problem with permissions... even when the user had dba rol, oracle didn't allow to alter any user. I had to grant him specific permission to change users.

GRANT ALTER USER TO username WITH ADMIN OPTION

AFAIK, on plsql the roles are not considered, so you must give specific permission to alter tables and users. Hope this will be usefull to someone.

>
> Look up usage for dynamic sql package dbms_sql or execute immediate.
> You cannot use ALTER inside PLSQL. e.g.
>
> begin
> execute immediate 'alter user blah account lock';
> end;
> /
>
> Regards
> /Rauf
Received on Wed Dec 01 2004 - 08:23:47 CST