Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...I need a SQL script to limit access to admin menu --HELP A NEWBIE, PLEASEI need a SQL script to limit access to admin menu --HELP A NEWBIE, PLEASE
Previous
 
Next
New Post
3/7/2008 6:45 PM
 

Dave,

Thanks for jumping in. Your Module was very close to what i want to do, but i noticed 3 shorcomings.

I will explain the shortcomings later, but first here is what i want to achieve.

I want to use Portal Signup Module where users create their own website with specific template(s) that i have created for them. Therefore, depending on the theme, they select only one template at the beginning of the site creation. They don't need the "wizard" option in the menu. That is one of the items i want to restrict. It will also be in their benefits because when you use the "site wizard" there is the potential for them to wipe out their site if they are not careful (i..e if they check "replace" for instance). I also want to remove few other admin options (Site Log, Event Viewer, Skins). I have two options. One option is to let the user become admin through portal signup by default and therefore let them be "admins" with the limitations i have setup. I saw TRTCONTROLPANEL allows to freeze certain icons in control panel and also choose the admin options. The other option i have is to create a role called "Site Owners" and create a page called "Site Admin". Then i can put the needed admin options on that page. TRTCONTROLPANEL also allows to assigns some permissions to "site owners" role. I have noticed all this while checking TRTcontrolpanel module with 4.8.0. But then when i was playing with the newly released 4.8.1, the General Settings of the Control Panel Setup will not work at all.

Here are the shortcoming of the TRTControlPanel. I wish you can tell me how to go around these and still continue testing it with the DNN 4.8.1

1. As opposed to standard dnn control panel, you don't have clear "View", "Edit" and "Design" modes. I noticed you have to click on "Design" several times, then "Preview" few more times, then "Design" again to get the three modes. You can tell only by watching how the screen view changes and realize whether you are in "view", "Edit" or "Design" mode.

2. In common tasks, you don't have "Roles"

3. When i cliked on "Contral Panel Setup", you can't go to "General Settings". You get the following error.

Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The file '/DeskTopModules/TRTControlPanel/controls/LabelControl.ascx' does not exist. ---> System.Web.HttpParseException: The file '/DeskTopModules/TRTControlPanel/controls/LabelControl.ascx' does not exist. ---> System.Web.HttpParseException: The file '/DeskTopModules/TRTControlPanel/controls/LabelControl.ascx' does not exist. ---> System.Web.HttpException: The file '/DeskTopModules/TRTControlPanel/controls/LabelControl.ascx' does not exist. at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.BaseTemplateParser.GetReferencedType(VirtualPath virtualPath, Boolean allowNoCompile) at System.Web.UI.BaseTemplateParser.GetUserControlType(VirtualPath virtualPath) at System.Web.UI.MainTagNameToTypeMapper.ProcessUserControlRegistration(UserControlRegisterEntry ucRegisterEntry) at System.Web.UI.BaseTemplateParser.ProcessDirective(String directiveName, IDictionary directive) at System.Web.UI.TemplateControlParser.ProcessDirective(String directiveName, IDictionary directive) at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ProcessException(Exception ex) at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseFile(String physicalPath, VirtualPath virtualPath) at System.Web.UI.TemplateParser.ParseInternal() at System.Web.UI.TemplateParser.Parse() at System.Web.Compilation.BaseTemplateBuildProvider.get_CodeCompilerType() at System.Web.Compilation.BuildProvider.GetCompilerTypeFromBuildProvider(BuildProvider buildProvider) at System.Web.Compilation.BuildProvidersCompiler.ProcessBuildProviders() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at TRT.DNN.Modules.ControlPanel.UI.ControlPanelEdit.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

 
New Post
3/7/2008 7:08 PM
 

Omer wrote

I am sure there are experts in DNN among you.  PLEASE HELP.

Same advice I gave you before. 3.5 years expertise says:

  1. Don't give out Admin roles
  2. Use third party modules to provide admin functionality
  3. Wait for Cambrian

Rob

 

 
New Post
3/7/2008 9:02 PM
 

Omer wrote: I need a SQL script to limit access to admin menu --HELP A NEWBIE, PLEASE

Not an SQL script, but an ASP script that works in the skin: 
<% If DotNetNuke.Security.PortalSecurity.IsInRoles(PortalSettings.AdministratorRoleName) %>
>...what you don't want anyone other than the admins to see goes here...<
<% End If %>
You can wrap that around whatever you don't want non-admins to see.

 
New Post
3/10/2008 7:39 PM
 

Make a note of each Item you change in case you want to restore it later.
 
SQL Script for hiding Admin Pages without removing them from the admin menu:
 
To Hide one in the menu:

UPDATE Tabs
SET
IsVisible = 0
WHERE (tabname = ' The Menu Item Name You Want To Hide' AND PortalId={PortalID})


To Reveal one in the menu just reverse it:

UPDATE Tabs
SET
IsVisible = 1
WHERE (tabname = 'Menu Item Name You Want To Hide'  AND PortalId={PortalID})

 
New Post
3/24/2008 7:52 PM
 

ROBAX wrote

 Omer wrote

 

I am sure there are experts in DNN among you.  PLEASE HELP.

 

Same advice I gave you before. 3.5 years expertise says:

  1. Don't give out Admin roles
  2. Use third party modules to provide admin functionality
  3. Wait for Cambrian

Rob

 

Rob (Or DNN Team),

    You stated to "wait for Cambrian". My question is this. (Have not read the new features of Cambrian yet) Is the DotNetNuke team planning on having it so you can set permissions for the Admin and Host functions as they are describing here? Basically all of the functions on the menu would be treated as a module so you can set permissions and not have to SQL backdoor the database tables? This seems like it would give great flexibility to permissions that need to be assigned to different role people. Granted, if you assigned people to be user roles, it would be "interesting" to lock them out of the other functionality unless you work it like the thrird party modules have it for generic users granting roles and not allowed to see Admin functionality.

I was going to ask a someone similiar question as i was hoping there was the same functionality as  WoW allows you to create and define custom ranks and permissions to guild controls yet i haven't found that here except what looks like a SQL solution? I hope they do consider that functionality for Cambrian as you suggest. Time to go blogging by the sounds of it.

Thank you,

Dean

 

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...I need a SQL script to limit access to admin menu --HELP A NEWBIE, PLEASEI need a SQL script to limit access to admin menu --HELP A NEWBIE, PLEASE


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out