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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 User Permission

Author  Topic 

yaman
Posting Yak Master

213 Posts

Posted - 2010-02-24 : 11:52:47
Sir ,

I want to set permission to users to access database objects.

I have created four users .

SNO. User Name Role / Permission
1.) 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 .

Yaman

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-02-25 : 01:57:50
Put such kind of problems in "new to sql server administration" forum block to get the fast response.

Vabhav T
Go to Top of Page
   

- Advertisement -