Apologies before I begin, but I am not that familiar with SQL Server, being
from an Oracle background...
I have a database that I have been sent and restored it onto our server. The
main tables are owned by user1.
User1 does not appear in the user list for the database. User1 does appear
in the user list for the server.
When I try to add User1 as a new user for the database, I cannot, "Error
15023: User or role 'user1' already exists in the current database."
Only one user is currently listed, 'dbo'. And 2 users are displayed in the
public role, 'dbo' and 'user1'. I cannot remove 'user1' from the public role
list, the 'Remove' button does not become enabled on selection.
What do I need to do to be able to add this user, 'User1', to the database
Thank you in advance for your help.