Updating MessageKey field....


Author
Message
StarkMike
StarkMike
StrataFrame User (450 reputation)StrataFrame User (450 reputation)StrataFrame User (450 reputation)StrataFrame User (450 reputation)StrataFrame User (450 reputation)StrataFrame User (450 reputation)StrataFrame User (450 reputation)StrataFrame User (450 reputation)StrataFrame User (450 reputation)
Group: Forum Members
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 Team
S
StrataFrame Developer (4.3K reputation)StrataFrame Developer (4.3K reputation)StrataFrame Developer (4.3K reputation)StrataFrame Developer (4.3K reputation)StrataFrame Developer (4.3K reputation)StrataFrame Developer (4.3K reputation)StrataFrame Developer (4.3K reputation)StrataFrame Developer (4.3K reputation)StrataFrame Developer (4.3K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
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.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search