Re: object level permissions being lost when migrating

Thank you Andrew. While I understand that the permissions are at the
Database level, that is why I am not understanding why I have an issue.
I have done the methods you linked to multiple times from 2000 to 2000 with
no issue.
If you have any other ideas, I would appreciate them ( most of the links
actually didnt' work for me, but I've been to those sites and done the
migrating logins process )


"Andrew J. Kelly" wrote:

Object permissions are at the db user level not the Login and are always
carried over with the db. But you may have lost the link between the login
and the user. Have a look at these:

http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers


http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000

http://www.sqlservercentral.com/scripts/contributions/1598.asp Script
Roles and Permissions


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"DSM_DBA" <dsmdba@xxxxxxxxxxx> wrote in message
news:ABFB1431-34F6-4B4D-85A4-A07AB03C391E@xxxxxxxxxxxxxxxx
Hi,
I'm moving databaes from 2000 to 2005 via either detach/attach or
backup/restore and object level permissions being lost.
I had first moved the logins and that seemed to work fine then upon
restoring the databases and leaving them at 8.0 compatibility ( which is
the
requirement of the application ) the explicit object permissions are not
restored.
There must be something obvious staring me in the face, but I don't see
it.
Any help or guidance would be appreciated.
Thanks,



.

Relevant Pages

  • Re: object level permissions being lost when migrating
    ... Object permissions are at the db user level not the Login and are always carried over with the db. ... http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp Moving Users ... http://www.support.microsoft.com/?id=246133 How To Transfer Logins and Passwords Between SQL Servers ... http://www.support.microsoft.com/?id=168001 User Logon and/or Permission Errors After Restoring Dump ...
    (microsoft.public.sqlserver.security)
  • Re: Cant read from database ??
    ... You also may need to worry about some permissions. ... http://msdn2.microsoft.com/en-us/library/ms345408.aspx Moving ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: User Permissions disappearing
    ... database and re-adding the users, it still won't let me attach the users to ... server information in security doesn't get updated. ... Here is some good info related to moving dbs and reestablishing permissions ...
    (microsoft.public.sqlserver.security)
  • Re: loss of permissions
    ... When you restore your database, you lose the permissions that had been ... Your problem is that your database's permissions (users, roles, and grants) ... are not the same as the database that you are restoring from. ...
    (microsoft.public.sqlserver.dts)
  • Re: Security Script
    ... Restoring or attaching a database does not alter permissions in any way. ... a mismatch between logins and users on the new server and be symptomatic ...
    (microsoft.public.sqlserver.security)