-
Título
Create User DDL script is blank or Create User statement is missing in script tab of Schema Brows -
Descrição
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.
-
Resolução
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.
-
Informações adicionais
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.