|
Home > Archive > MS SQL Server Tools > November 2006 > Scripting Object Permissions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Scripting Object Permissions
|
|
|
| Hi 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
| |
| Erland Sommarskog 2006-11-26, 7:13 pm |
| 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, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
| |
| Paul A. Mestemaker II [MSFT] 2006-11-27, 7:17 pm |
| 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/
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9887D74C93FA
2Yazorman@127.0.0.1...
> JT (Jthayer@online.nospam) writes:
>
> No, the Generate Scripts wizard is the only place where you can do this.
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
| |
| Erland Sommarskog 2006-11-27, 7:17 pm |
| Paul A. Mestemaker II [MSFT] (PaulMest@online.micro-soft.com) writes:
> 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.
Thanks for filling, Paul! I have not have the time yet to install the
CTP of SP2. (Yeah, I know it's a real shame...)
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
|
|
|
|
|