Automate setting permissions to databases (SQL 2005)?
- From: "AdamM" <adam@xxxxxxxxxx>
- Date: Thu, 22 Jun 2006 11:40:57 -0700
I set a long list of granular user database permissions with every reinstall
of my development database and I would like to automate this work with a
script instead of doing this manually in SQL Server Management Studio.
Is there a security settings export to file option? Or maybe some script
samples that show how to set user permissions?
I saw this example, but it requires both old and new databases to be running
at once. I reinstall the same PC repeatedly so this doesn't work for me:
http://www.sql-server-performance.com/bm_object_permission_scripts.asp
Thanks!
Adam
.
- Follow-Ups:
- Re: Automate setting permissions to databases (SQL 2005)?
- From: Andrew J. Kelly
- Re: Automate setting permissions to databases (SQL 2005)?
- Prev by Date: Monitor SQL Statements
- Next by Date: Re: Monitor SQL Statements
- Previous by thread: Monitor SQL Statements
- Next by thread: Re: Automate setting permissions to databases (SQL 2005)?
- Index(es):
Relevant Pages
|
