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 |
|
subhaoviya
Posting Yak Master
135 Posts |
 Posted - 2014-03-26 : 08:17:46
|
| Hi, I have created one database DB1, I need to create access permission for user1 to access only that newly created databse DB1 and need to grand permission for create table, sp,... How to do that?I have created user under security-->logins with server role public. but the user1 not able to create table with this permission level.ThanksSubha |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-03-26 : 08:22:47
|
| Give the user Owner permissions, right click the logon go to User Mappings, select the DB and select db_Owner.We are the creators of our own reality! |
 |
|
|
subhaoviya
Posting Yak Master
135 Posts |
Posted - 2014-03-26 : 08:28:34
|
| Thanks sz1 |
|
|
|
|
|
|
new user