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 |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2010-02-25 : 07:59:37
|
| Sir ,I want to set permission to users to access database objects.I have created four users .SNO. User Name Role / Permission1.) user1 I want to set ADMIN ROLE 2.) user2 I want to set only "select permission "3.) user3 I want to set only "DML permission" NOT DDL permission 4.) user4 I want to set "DBA permission"Sir how can i set this permision to all different users.Please help me out Sir .YamanYaman |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-02-25 : 12:29:16
|
| create different Role(s) and assign it to individual users.Example: Role1 --> assign db_reader (only read operation) Role2: Assign db_reader + Writer + Execute permisionsetc etc ...Assign Role1 to User1 and Role2 to User2 ...With RegardsSR |
 |
|
|
|
|
|
Related to User Permission