Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dsathishcse
Starting Member
3 Posts |
 Posted - 2008-05-26 : 03:09:14
|
| 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 Sathish kumar D |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-26 : 03:30:07
|
| Use GRANT T-sql command. See books online for syntax. |
 |
|
|
|
|
|
How to assign Database access privilege to user?