StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Role Based Security
»
Updating MessageKey field....
Updating MessageKey field....
Post Reply
Like
0
Updating MessageKey field....
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
StarkMike
StarkMike
posted 17 Years Ago
ANSWER
Topic Details
Share Topic
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
Reply
Like
0
StrataFrame Team
S
StrataFrame Team
posted 17 Years Ago
ANSWER
Post Details
Share Post
S
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.
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search