How to automatically script the securables assigned to a SQL account?
sql, sql-server, sql-server-2008, t-sql
Solution
I had the same problem and solved it with Justins suggestion.
- Right-click a template/example user in the database hive.
- Choose `properties`, `securables`.
- Make a change
- Do Ctrl+Shift+N to get a script of the change.
Problem
I want to generate a script to assign a user account to some securables, e.g. Table:Select. How to do this?