When restoring database from as soon as occasion to a different one generally has to relink SQL Server Logins to the Database Person.
That is usually achieved with one of many following procedures.
Deprecated sp_change_users_login Saved Process
use <database> go sp_change_users_login 'Update_one', '<datbase_user>', '<sql server login>' go
ALTER USER Command
use <database> go ALTER USER [<datbase_user>] WITH LOGIN = [<sql server login>] go
These instructions will re-link orphaned Database Customers to a corresponding SQL Server Login.
Is it doable to interrupt this relationship with out deleting both the SQL Server Login or the Database Person?
- Deleting the Database Person will take away the permissions within the database.
- Deleting the SQL Server Login will take away the password. (Hashed worth; unknown to DBA)
- I linked a Database Person to a SQL Server Login that could be a System Account.
I’ve had a have a look at the
sys.server_principle DMVs, however they aren’t modifiable.