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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-05-02 : 15:46:38
|
| I have set up all new Roles assigned different views, table access to each user i set up.Whilst setting this up - i could do script to generate the script.Is there a way to get this script after the effect - some roles i forgot to generate script.I know im being lazy - i could write the entire script out but thought maybe there a way to get this .Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 20:21:10
|
| You can genarate script in ssms. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-05-03 : 22:07:12
|
| How do you do it after you have added the role...and databases views/tables permissions... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 22:34:33
|
| Right click on th role and choose script database role as -> create to in ssms. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-05-04 : 08:32:03
|
| That only gives meCREATE ROLE [ROLE_EMPLOYEE] AUTHORIZATION [dbo]It does not give me the securables or the users...----If set up from start and add securables (tables etc) and hit script i get everything and i can then go recreate..Just not after i have done it. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-04 : 18:08:40
|
| When you create role and choose script, sql scripts your actions. Once done with that, you have to use tasks -> genarate scripts to script whatever you like. |
|
|
|
|
|
|
New Role