Scripting object level permissions

Last Post 21 Jan 2011 10:03 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dlwwinnet
New Member
New Member

--
21 Jan 2011 09:32 AM
In SQL 2005 you could right click an object and script it.  As long as the Tools/Options/Scripting 'Object level permissions' was set to 'true', the permissions were also scripted.  I'm not finding this option in SQL 2008 R2.  I know you can use the 'Generate Script' wizard, but that seems cumbersome.  Is there any place to set this option in SS 2008 R2 Management Studio?
rm
New Member
New Member

--
21 Jan 2011 10:03 AM
Set script permission to true in Tools/Options/sql server object explorer/Scripting.
You are not authorized to post a reply.

Acceptable Use Policy