How to change the owner of SQL database
1. Go to SQL Server Management
2.Select the database ID for which you want to change the owner
3.Execute the query as below (Click on New Query)
exec sp_changedbowner ’sa’
It is using Windows authentication for SQL login.
The above query will change the database owner to ’sa’ all Sytem Administrators.
Following is what is recommended for client copy.
Copy Client
Use
SAP delivers a client with a standard configuration for the Solution Manager.
Client 000 is updated in Support Packages, so it is the source for client copy.
Client 001 contains users for the Java Stack, for communication between ABAP and Java, so client 001 must be the source client for users.
Requirements
You have logged on to the new client with user SAP*, password PASS.
To copy a client, you must release the SAP* user with a profile parameter. The user is locked for security reasons.
login/no_automatic_user_sapstar
Activities
Use the following parameters:
Source: Client 000
Source User: Client 001
Target: Your new client
Profile : SAP_ALL
Information
Delete the profile parameter ‘login/no_automatic_user_sapstar’ when you have created the first user in the new client. Restart the system to make the changes effective.
See Also:
Creating a client and setting up the client attributes