Post reply

post upgrade issues with permissions

  • July 22, 2003 at 6:00 am

    #81207

    Can anyone assist with the following prob after upgrading from sql 6.5 to 7.0. During the upgrade a few errors were flagged in the .err file regarding aliased logins (these subsequently were not created on the import server). I went ahead with the test upg anyway, and now I've discovered that permissions have not been moved across correctly. Is there any way of setting up the permissions correctly without having to do it all manually? Any advice appreciated. Thanks,


    LP

  • July 25, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • July 25, 2003 at 8:03 am

    #467068

    When doing DTS transfers, scripts are generated for each step in the process. You should be able to just generate the SQL script for the database structure, then use the permission pieces to recreate the information on the new database.

    Guarddata-

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply