I'm in the Schema Browser and selecting a User and going to the Script Tab and the page is blank where the DDL script for the user should be.
Go to the Script Options when in the script tab and go to the Users tab and uncheck the checkbox "Grants on the user's objects to other user/roles". Click OK and the DDL script should appear.
Why isn't the Create User statement there when the "Grants on User's objects to other user/roles" is checked?
The Create User statement (DDL) not showing up when the “Grants on user’s objects to other users/roles” is checked is as designed. This is because if the script to create the user were included, and a user ran it, the user would have just been created, and would not have any objects created yet. So all of the grant statements would fail. The “Grants to the user” option includes the user DDL because these are grants on other schema’s objects, being granted to the user who is created by the DDL.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center