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 |
|
bugulgad
Starting Member
21 Posts |
 Posted - 2008-07-14 : 16:23:26
|
| From sql server mgmt studio I can generate a script for database users but it does not extract out any of their permissions. Does anyone know of a system stored procedure that does this or am I missing the command option from SSMS |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-14 : 16:52:48
|
| sp_helplogins sp_helprotect for object level permission: |
 |
|
|
bugulgad
Starting Member
21 Posts |
Posted - 2008-07-14 : 18:59:40
|
| I already checked those out, not quite what I am looking for.I really want a generated script that would GRANT all the permissions back to users. If someone has a 3rd party tool or a custom script that does that I would be interested, but I would also like to know if it can be done with SQL 2005 Native tools also.I had a DBArtisan tool(now expired) which would generate a script which would add users back to a database and EXEC sp_addrolemember, which would give all the users their specific perms back as well.Anyway to do the same with SQL 2005 tools? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-14 : 22:38:01
|
| You can specify to script permissions when script db in ssms. |
|
|
|
|
|
|
scripting out user permissions