Re: Script DB Object Level Security with SQL2005
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 20 Dec 2007 15:10:53 -0800
KevinL (KevinL@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
We regularly need to take production DB backups and restore them onto our
development SQL Server boxes for testing (SQL2005 SP2). Since DB level
security is much different between production and stage, we need to script
stage rights (server and object level) and refresh those rights onto the
restored production DB. I was able to do that with EM in SQL 2000, but am
unable to do it with 2005 (SP2). I have tried (I think) every possible
option in Management Studio under Tasks / Generate Scripts for the DB and
none generate SQL for object level security. Is this a "bug" with SQL2005
SP2? I believe we were able to do it with SP1, but I don't recall which
options we chose.
There is a scripting option "Script Object-level Permissions". that you
can use when you use the Generate Scripts task.
Under Tools->Options there is a new page "Scripting" where you can set
options for when you script individual objects from Object Explorer.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
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
.
- Prev by Date: Re: Not allowed to switch authentication modes
- Next by Date: Re: Not allowed to switch authentication modes
- Previous by thread: Re: Not allowed to switch authentication modes
- Next by thread: Re: Script DB Object Level Security with SQL2005
- Index(es):
Relevant Pages
|
|
