| | | 
StrataFrame User
       
Group: StrataFrame Users Last Login: 07/09/2008 2:20:16 PM Posts: 436, Visits: 944 |
| As you can see in the image below I have chose MessageKey for the Denied Action and specified a MessageKey. What I would like to do is change the message key for all 100 of my permission items. I was wondering if you could point me to the table that this information is stored in so I could use T-SQL to update the table rather than doing each one individually.

Thanks |
| | | | 
StrataFrame Developer

Group: StrataFrame Developers Last Login: Yesterday @ 1:09:23 PM Posts: 2,686, Visits: 1,888 |
| Yep, it's the SFSPermissions table. The two fields you'll be interested in are pm_BlockedAction which is an INT field with a value corresponding to the DeniedActions enumeration. And the other field is pm_BlockedMsgOrKey which is NVarChar(1000) and contains the value you want to change.
www.bungie.net |
| |
|
|