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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-04 : 07:59:01
|
| Ivan writes "how do i create roles with given privilege for:catowner-sysadmin,dbownercatadmin-all privileges on all tablescatuser-read privileges on all tables" |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-04 : 15:32:15
|
| Can you use Windows account groups or are you limited to SQL authentication? |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-04 : 21:48:38
|
| create role using sp_addrole, apply the appropriate permissions using grant/deny command (whichever is applicable), then add the logins as members of roles that they're supposed to be included--------------------keeping it simple... |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-04 : 23:12:14
|
| Books Online is kewl.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
creating roles with privileges