how to generate create user script with password in TOAD
Yong Zhang <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Hi, Toad users, I am using TOAD 10.5.1.x version. When I connect to Oracle 10g R2 database using schema browser to generate create user script, it generate the following code: create user username identified by values 'somevalues' default tablespace users; which is very convenient for dbas to drop and recreate the users in the same or another database without having to know the passwords for a particular user. But when I connect to 11g database, it does not generate the password values: create user username identified by <password> default tablespace users; Does anyone know where to configure the TOAD to generate the same script as Oracle 10g? Or where do I have to tweak the parameters in Oracle 11g database? I would appreciate if someone can answer my questions or point me to some docs on the web. Please don't ask me why I have to do it this way, but I have to do it quite often. Regards. Yong