March 4, 2010 at 2:12 pm
Hello again.
I am using MS SQL server express 2008.
I have created a database, and i want to add a user to it.
In the general tab of User - new, there are three fields im able to type in. User name, Login name, Default schema.
Im guessing Default schema, is some standard permissions to the new user?
If user name, is the name of the new user, what do i specify in the login name?
Thanks in advance.
March 7, 2010 at 8:32 am
In SQL Server there are logins and users. Logins are set up in the instance via the Security folder and give access to SQL Server for either a Windows user or a SQL Server user. Users are then created in individual databases under the and give a login access to the database. You can create both a login and a user at the same time by going to the Security folder under the database instance, defining a login and using the User Mapping tab to create the database users.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply