Forums
This topic is locked
Data instead of Schema with Custom Server Behavior
01 Nov 2002 18:54:08 Joe Dog posted:
<font face='Verdana'></font id='Verdana'>Background:
I've built an online security package that contains user and group permissions similar to NT permissions. Thing is that when securing an object on the page, I'm checking the user, his group, and the permissions available to him by tapping the sql db and searching the permission by text. This happens when the user accesses the page. I'm manually writing my code as asp - If checkPemission("this permission", userID) - asp end; where "this permission" is a text value in the sql db, indexed by users and groups.
Need:
I would like to build a custom server behavior that will allow me to access the sql server during design time and pull a listing of those records in a pulldown menu. I can then choose the permission I want and it will add the option value "this permission". I've built a version of this by editing the DW script pages to contain hardcoded HTML option values, but I add and remove permissions during development, so I'd rather tap into a dynamic source. The security system works smoothly and is powerful as well as scalable, but I would like my design to be a bit more streamlined. Any suggestions would be greatly appreciated.
Thanks in advance,
MHz