Create script for a user

Toad for Oracle - Beta
1

When I go to Schema Browser and follow the steps below the script either gets generated with only grants and no CREATE USER statement or no script gets generated if the user did not make grants to other users or roles. I expected the CREATE USER statement along with all the grants. Please see the attached.

Example2S2
Example2S21920×1080 181 KB
Example2S1
Example2S11920×1080 188 KB
Example1S2
Example1S21920×1080 234 KB
Example1S1
Example1S11920×1080 188 KB

right click on a user, select Create, select script, script options, users, check "Grants on the user's objects to other users/roles", and then click okay

2

If the script were to create the user, and then also include the grants on the user's objects to other users and roles, then all of those grants would fail, because the objects don't exist yet.

3

I see the logic now. Thank you

1 Like
4

It sounds like Generate Schema Script will give you what you want - create the user, objects and grants on those objects.

5

Yes. That will do it. Thank you

1 Like