I'm connecting to a SQL Server database and using the Creation Script tool in the Object Explorer. The script does not contain any of the Grant Permissions.
Script Option for Permissions needs to be checked.
1. Right-click the table in question and select View Details.
2. Click on the Script tab.
3. Under the Script Options check boxes, make sure the 'Permissions' check box has a check mark.
4. Close the Viewer Table window and use the Creation Script tool again to see if the Grants now show up.
