Toad World® Forums

How do I get a create script for a user?

When I use Schema Brower, I select a schema, but I want to get the create script for that user/schema. How to I get that?

Thanks,

Lyle

To get a script to create the user:

Go to SB-Users. Select the desired user on the left hand side (LHS). Choose the Script tab on the RHS.

To get a script to create all of the user’s objects:

Go to Database -> Export -> Generate Schema Script