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 |
|
lohumi
Starting Member
6 Posts |
 Posted - 2011-04-07 : 07:10:06
|
| Hi I want to implement some security on my DB which is running over intranet.All the users on LAN are using it .But i want allow the users to create new DB or any other delete queries.how can i do that?Lohumi |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-04-07 : 07:34:36
|
| To give DB Create Permission you must have sysadmin permissionOpen SSMS,Expand your instance,Expand Security,Expand Logins,Right click on user(To whom you want to give permission) Click on property, This will opens new window click Server Roles and right side it will show all server role name and check box click only dbcreator.This will give user to create Database permission.If you need to give same user delete query permission First you need to mount this user for DatabasesFor that you need to click on user mapping here you see all database name select database and Under Database role membership click check box db_ddladmin (To give create delete and insert)Raghu' S |
 |
|
|
|
|
|
delete query restriction on database