Alvin,
See
Re: Copying Security Roles Message #
949750>
>I have created a role in SQL 7, added users and made numerous changes to their permissions.
>
>I would like to recreate this role in another SQL database and was wondering if there was a way to script the created role.
>This way, I dont have to recreate the role and reapply the permissions.
>
--sb--