时间:2021-07-01 10:21:17 帮助过:44人阅读
当你从现有的bak文件,恢复数据库时,如果数据库本身带有一个用户:比如用户叫:DemoUser.
你无法创建一个相同的用户并mapping这个用户到数据库, 并且你无法删除数据库的用户:DemoUser.
- <br>GO <br>ALTER AUTHORIZATION ON ROLE::[aspnet_Membership_BasicAccess] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON ROLE::[aspnet_Membership_FullAccess] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON ROLE::[aspnet_Membership_ReportingAccess] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON ROLE::[aspnet_Profile_BasicAccess] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON ROLE::[aspnet_Profile_FullAccess] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON ROLE::[aspnet_Profile_ReportingAccess] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON ROLE::[aspnet_Roles_BasicAccess] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON ROLE::[aspnet_Roles_FullAccess] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON ROLE::[aspnet_Roles_ReportingAccess] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [dbo] <br>GO <br>GO <br>ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [db_owner] <br>GO