Toad World® Forums

SOME IMPROVEMENT in creating ddl from USER


#1

Maybe would be useless to add password string in to create user statement.
Now we have:

CREATE USER SCOTT
IDENTIFIED BY
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
It can be:
CREATE USER SCOTT
IDENTIFIED BY values ‘’ --select password from user$ where name=…
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP

It would be great easement for administrators, when moving users into other instance …

Regards Piter


#2

Hi Piter,

Very nice catch indeed .

I have checked with our Oracle Domain expert, we will certainly include this option for you in the next build, we can get encrypted password is available from dba_users view.

CREATE USER “TESTING” IDENTIFIED BY VALUES ‘14594B915E24E5C4’ DEFAULT TABLESPACE “USERS” TEMPORARY TABLESPACE “TEMP”;

In this way, we can retain the existing password of the user and since it is encrypted, it does not pose any security threat for users. Keep an eye on this space for more enhancement .

Thanks and regards,
Bruce


#3

Hi Piter,

Just a quick note to you that we have added a new preference for users extractDDL to include password with the sql as per your request. It will be included and available to you in the next beta build.

Thanks and regards,
Bruce


#4

Thanks! :wink: