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 |
|
ddatta8
Starting Member
7 Posts |
 Posted - 2010-01-30 : 17:35:44
|
| I am totally unfamiliar with sql server and I am learning it by experimenting with it. I am the sql server administrator.I want to create a new database and a new user and give the user access to the new database only. The user should not be able to access other databases or modify access rights of other users. How do I create the login for a new user in order to implement the restrictions mentioned above? Please help. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-31 : 02:48:59
|
| Create new Server LoginMake sure that that use only has the Server Role "Public" (in particular not SysAdmin that will let them see everything!)Allow that user access to the specific databasseGRANT the user permissions in that database = e.g. db_DataReader and db_DataWriter which will allow Read/Update access.In the future you could set up a new Role in the Database for the exact permissions you want. Lets call it "MyRole" so then you make your user a member of the MyRole role, and then that user has the permissions granted by MyRole.You can set MyRole for each individual object in the database - so you could GRANT SELECT permission on one table, and SELECT, UPDATE, DELETE permissions on another table. |
 |
|
|
ddatta8
Starting Member
7 Posts |
Posted - 2010-02-02 : 12:27:06
|
| Thanks a lot! Can you tell me where do I go to to select GRANT options for a particular user? |
|
|
|
|
|
|
restrict user access