Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    1

    Unanswered: Copy roles and users

    I have a data base that will have to be recreated each year. I need to copy the users and roles and the security for the tables to the new database. All the tables will be the same.

  2. #2
    Join Date
    Oct 2002
    Location
    BC, Canada
    Posts
    17

    Re: Copy roles and users

    Hi there,

    You can use DTS to copy SQL objects, including users and roles.

    Cheers, Marin

    Originally posted by rstout
    I have a data base that will have to be recreated each year. I need to copy the users and roles and the security for the tables to the new database. All the tables will be the same.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You should be able to create a script of all users, roles, and permissions by using SQL Enterprise Manager. Right click on the database, and look for Generate SQL Script. Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •