I have a user who is a memebr of dbcreator role but not sysadmin role. When this user attaches a database copied from another server he becomes the owner of the database. Everything is fine up to this point. When this user then tries to use that database he receives an error message that he doesn't have access to it. Quick check shows that this user is the owner in master..sysdatabases but in the attached database dbo still associated with "sa" login as it was on the original server.
Any idea how that user can make himself the real owner of the database (with access and all permissions) without including him in sysadmin role (and without involving sa)?
Thanks a lot.