Create script for a user

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.

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

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.

I see the logic now. Thank you

1 Like

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

Yes. That will do it. Thank you

1 Like