Posted by AlterEgo on 01/26/07 00:04

Inna,

If on SQL 2K, use Enterprise Manager.
Right click the database/All Tasks/Generate SQL Script.
Click the Options tab and you can select all of the logins and object
permissions you need.

-- Bill


"Inna" <mednyk@hotmail.com> wrote in message
news:1169753046.376196.16430@v45g2000cwv.googlegroups.com...
> Hello all,
> I am looking for the script, which I believe exists already.I need to
> be able to populate the script for security of one database and
> apply it to another database, even if it is located on another server:
> 1. All logins which not exist have to be created and which exists
> ignored including the NT accounts
> 2. Users same as the old database + the existing ones stay in database
> 3. Passwords for the new logins.
> 4. All permissions/grants on all objects for the users that exists
> (usually it's the case) and ignore those that don't.
> I have script which does some of it, but it's not perfect, so every
> time there are some errors.
> Please let me know, if you need me to email script that I have. It's
> pretty long so I cannot just post it in here.
> Thank you in advance.
>

[Back to original message]