CREATE USER Scripts - removing comments

Toad for Oracle
1

TOAD 9.7.2.5 - Using Schema Browser to generate CREATE USER Scripts. A nice
handy facility when migrating databases. I’m sure there is some option that will
skip adding the comments in the script, but I can’t seem to find it. Can anyone
point me in the right direction?

Thanks,

  • tim

CREATE USER ABCDEFG
IDENTIFIED BY somepassword
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE STANDARD_USER
ACCOUNT UNLOCK;
– 1 Role for ABCDEFG
GRANT SOME_SELECT_R TO ABCDEFG;
ALTER USER ABCDEFG DEFAULT ROLE ALL;
– 1 System Privilege for ABCDEFG
GRANT CREATE SESSION TO ABCDEFG;

2

Sorry, no way to turn those comments off.

3

Okay John, thanks for the insight. I’m sure that some people find those comments
useful and other people probably consider them “clutter”.

You folks are great for the quick response out here.

Thanks again,

  • tim
4

You’re welcome. Feel free to post an idea into the idea pond to make
them optional or just remove them. If the idea gets some traction, this
could be easily changed.

http://www.ToadIdeaPond.com

-John