|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Scripting Object PermissionsHi all,
I am wondering if there is an option I can set in SSMS (2005) that will allow me to specify that I want to script object permissions when I generate a create script by right clicking an object in Object Explorer. I know that there used to be such an option with ISQL.exe in version 2000. (I am not talking about the option to script permissions using the scripting wizard that comes up with the Database/AllTasks/Generate Scripts task.) Thanks -- John JT (Jthayer@online.nospam) writes:
> I am wondering if there is an option I can set in SSMS (2005) that will No, the Generate Scripts wizard is the only place where you can do this.> allow me to specify that I want to script object permissions when I > generate a create script by right clicking an object in Object Explorer. > I know that there used to be such an option with ISQL.exe in version > 2000. (I am not talking about the option to script permissions using > the scripting wizard that comes up with the Database/AllTasks/Generate > Scripts task.) Thanks -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx In SQL Server 2005 RTM and SP1, Erland is right... however, in SQL Server
2005 SP2, we've introduced a new scripting options dialog (Tools | Options | Scripting). You would want to set the "Script Permissions" to True. To find out more about SP2, (and to download a Community Technology Preview) please visit this site: http://www.microsoft.com/sql/ctp.mspx Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ Show quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns9887D74C93FA2Yazorman@127.0.0.1... > JT (Jthayer@online.nospam) writes: >> I am wondering if there is an option I can set in SSMS (2005) that will >> allow me to specify that I want to script object permissions when I >> generate a create script by right clicking an object in Object Explorer. >> I know that there used to be such an option with ISQL.exe in version >> 2000. (I am not talking about the option to script permissions using >> the scripting wizard that comes up with the Database/AllTasks/Generate >> Scripts task.) Thanks > > No, the Generate Scripts wizard is the only place where you can do this. > > > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Paul A. Mestemaker II [MSFT] (PaulM***@online.micro-soft.com) writes:
> In SQL Server 2005 RTM and SP1, Erland is right... however, in SQL Thanks for filling, Paul! I have not have the time yet to install the> Server 2005 SP2, we've introduced a new scripting options dialog (Tools > | Options | Scripting). You would want to set the "Script Permissions" > to True. CTP of SP2. (Yeah, I know it's a real shame...) -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics