How to assign Database access privilege to user?

Question

How to assign Database access privilege to user?

satishkumar.d

Old Hand

Points: 308
More actions
May 26, 2008 at 12:56 am

#71604

Hi friends,
I have created a database DB1 using CREATE DATABASE DB1 command. Then i created login name using CREATE LOGIN login1 WITH PASSWORD = 'password1' command and created user name using CREATE USER user1 FOR LOGIN login1 command. Now i have to assign the user1 to the database DB1.
Any one please tell me how to assign DB1 access privilege to user1?
Thanks in Advance....

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

preetha.sathyamoorthy Ten Centuries Points: 1180 More actions · Answer 1

Right Click on login1 ,

Select Properties -> Select User Mapping -> click on the checkbox near to the database name which one you want to assign and remove other database if you don't want that. But, you can assign more than one database for the same login.

If you assign the database for login1, it will be applicable for user1 also.

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 2

Also asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103571

N 56°04'39.16"
E 12°55'05.25"

satishkumar.d Old Hand Points: 308 More actions · Answer 3

Hi Rookie,

Could you please tell me how to perform the same in sql command prompt?

preetha.sathyamoorthy Ten Centuries Points: 1180 More actions · Answer 4

Hi,

You can solve this problem with GRANT ALL. For further assistance, check the following link.

http://msdn.microsoft.com/en-us/library/bb153640.aspx