I am using WSS 3.0 and RadMenu 2.0. I have gotten the RadMenu control installed and working with WSS 3.0 displaying the site map across the top of the page.
What I am looking to do is have a hierarchical menu displayed at the top of the master page. This menu should be dynamically created based on a users permissions to menu items defined in a SQL Server table. That table will contain the ID, ParentID, Name, and URL for each menu item, as well as a column containing a CSV list of users who can access each menu item.
What I need to be able to do is execute a stored procedure, passing in that users user name. That procedure will dynamically return a list of menu items specific to that user.
Has anyone ever successfully accomplished that before? What is the best way to approach this within SharePoint? Any help would be greatly appreciated.
Thanks,
Eric
What I am looking to do is have a hierarchical menu displayed at the top of the master page. This menu should be dynamically created based on a users permissions to menu items defined in a SQL Server table. That table will contain the ID, ParentID, Name, and URL for each menu item, as well as a column containing a CSV list of users who can access each menu item.
What I need to be able to do is execute a stored procedure, passing in that users user name. That procedure will dynamically return a list of menu items specific to that user.
Has anyone ever successfully accomplished that before? What is the best way to approach this within SharePoint? Any help would be greatly appreciated.
Thanks,
Eric