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-04-25 : 03:10:20
|
| Hi, I newly created one database (using creat database testdb ). After that i created login name and password for that database ( using create login login1 with password = 'pass1'; use testdb; command) and i created user for that login name ( using create user user1 for login login1 command). Then i connected testdb database using login1. But when i trying to create table in that database, it thrown error. Anyone please tell me that how to assign all privileges to the user user1?Sathish kumar D |
|
|
vinoth86
Starting Member
27 Posts |
Posted - 2008-04-25 : 03:27:30
|
| Right click on the username.You ll see properties.click on it.There is a permission field..you can grant,the privileges..watever you need it. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-25 : 04:02:45
|
| or use T-SQL GRANT command |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-04-28 : 04:59:20
|
| exec sp_addrolemember @rolename='db_owner',@membername='user1'you need to be dbo on the database or sa when you execute this--------------------keeping it simple... |
|
|
|
|
|
|
How to Grant permission to user?