Furthermore: I tried something, but now I see that many users are only created so they can access the application. The users have no objects, but are granted select/insert/etc rights to access the application-schema. Great!
Now I think to use to create a script from selecting DBA_USERS to create all those users at the other db.
How do I transport the password?
The following statement fails:
SELECT 'CREATE USER '||user_name||' IDENTIFIED BY '||password||';'
Is there a trick to create a users password by using the encrypted password in DBA_USERs?
Last edited by efrijters; 09-11-2003 at 10:27 AM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
you can get the password by one method, but before populating into that table, you need to expire the acc & when login the user will have to enter new password. then you can capture old & new pass in the table using a function and assinging a profile.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"