I need to create a new user login, and give user access to the database (2005 version).
> Security, Logins, . . created MikeS
> MyDatabase, Security, Users . . Here is has:
User Name: ____________
Login Name: ____________ . . .
Is the Login Name the same as the the User Name? What goes there?
Then how do I "give user access to the database"?
The instructions say:
Make sure the Permitted Roles are
"public", "db_accessadmin", "db_securityadmin", "db_dlladmin", "db_datareader", "db_datawriter"