How to create a user in DB MS SQL Studio

Below steps will guide you to create user in Microsoft SQL Management Studio and in Siebel.

First create login, open MS SQL Management Studio and connect with database.Run below SQL statement.

CREATE LOGIN <user-name> WITH PASSWORD = '<password>';
CREATE LOGIN EAIUSER WITH PASSWORD = 'EAIUSER';

Now create user in database. The SQL create user command takes the following syntax:

create user <user-name> for login <login-name>
create user EAIUSER for login EAIUSER

Now you need to provide permissions to newly created user in database. There are tow ways based on user role in the organization select the appropriate method. One to provide the rights of specific database or assign the Membership role to newly created user.

Expand the DB and go to Security/Users and find or add filter for new user as seen below. Right click and open properties. Now go Securables and click on Search button.

A new window will popup as seen below. Check the Specific Objects and click OK button.

Select Object Type and from Objects window check Databases and click OK button.

From the Select Objects window click on Browse button. Select the Database and click OK button. Click OK button of Select Objects window.

Now on properties window check the grand check box for Select, Update, Insert and Delete. Click OK.

OR by pass all the above steps click on Membership from the users properties window and from the Roles select the appropriate Role and Click OK.

Open the Siebel Application and from site map go to Employee or Users view create new or clone the existing user and in user name type the same user name and save.

ITCanopy