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 |
|
whizsql
Starting Member
17 Posts |
 Posted - 2008-12-08 : 16:46:20
|
| Hi,I used SQL server 2005 to create a database role and its securables (permissions).Now, I want to generate script of those permissions...to migrate it over to QA and so on.I tried the Generate script feature in SQL Server 2005 and it returned only 'Create Role' statement.It didnt pull any of the securables...could you please help me with this? Thanks ! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-09 : 08:32:35
|
| You have to match database user with SQL login when you transfer accross environment. |
 |
|
|
whizsql
Starting Member
17 Posts |
Posted - 2008-12-09 : 09:57:50
|
| I am having trouble in generating the permissions script. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-09 : 10:19:26
|
| As you migrate your DB to other environment with Backup/Restore,all database level permission will be migrated as well. The only thing you have to do is match database user with Login SID. |
|
|
|
|
|
|
Database role script from SQL Server 2005