[T-SQL] Can you script role permissions |
| Can you script role permissions Posted: 21 Jun 2013 01:54 AM PDT Can you create a SQL statement (that will end up in a stored Proc) that sets all of our custom views ('zvw%') with Insert, Select, Update access.. for a given role?Trying not to have to go in and add new views and tables.. everytime a someone forgets to add their new view/table to the correct roles. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment