Best Practice for the database owner of an SAP database.

[laurie_mcginley]

We recently had a user account removed from our SAP system when this person left the agency. The account was associated with the SAP database (he created the database a couple of years ago).

I'd like to change the owner of the database to <domain>\<sid>adm (ex: XYZ\dv1adm) as this is the system admin account used on the host server and is a login for the sql server. I don't want to associate the database with another admin user as that will change over time.

What is the best practice for database owner for and SAP database?

Thanks

Laurie McGinley

[ken_halvorsen2]

Hi Laura

I'm not sure if this is best practise or not, but I've always had the SA user as the owner of the database. It just makes it easier for restores to other systems etc.

Ken

[laurie_mcginley]

Sorry it has taken so long to respond. Thanks Ken. I think that is the direction we will go then. Makes sense to me.

Laurie