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 |
|
Moussie
Starting Member
20 Posts |
 Posted - 2004-03-17 : 01:03:38
|
Hello!We're moving our DBs to a shiny, new (and noisy as hell )server. I have tried out the method described here (fromsql-team):http://www.databasejournal.com/features/mssql/article.php/1479841and it seems to work well, with ONE major problem,it does not take into account the moving of sql-logins (we're not using windows authentication), roles and permissions. We have most of our permissions assigned to roles, but not quite all  ,so there is a need to script out the individual object permissions for each user...If I in EM select a database, the All tasks, and then"Generate SQL script" and hook the "Script object-level permissions" it does not scriptout the individual GRANTS for every login....and there I am stuck. Any suggestions? :)Moussie |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-03-17 : 20:33:02
|
| Hmmm... This seemed to work for me when I just tried it. What are you getting? No information at all? Or some GRANTS but not everything you expected?--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
 |
|
|
|
|
|
Moving to new server,need every logins permissions