Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

telerik -- supercharge your DNN websites
  Ads  
Aspose - The .NET & Java component publisher
 


  Sponsors  

Meet Our Sponsors

SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  I need a SQL script to limit access to admin menu --HELP A NEWBIE, PLEASE
Previous Previous
 
Next Next
New Post 2/21/2008 5:43 PM
User is offline ROBAX
1885 posts
5th Ranked


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

Giving out Admin accounts to random people is unnecessary and is asking for trouble. Site owners don't have to have admin access to content-manage a portal and I never provide admin access myself. Most relevant Admin functionality can be provided to non-admins by using third party modules and the rest is coming in the next major "Cambrian" release of DNN. 

Rob

 
New Post 2/22/2008 8:27 PM
User is offline Omer
9 posts
10th Ranked


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

It looks like i got more replies to my help request than i can see.

I would like to able to read all replies so i can explore help offered to resolve this issue.

thanks

 
New Post 2/25/2008 5:09 AM
User is offline John
233 posts
ewds.strath.ac.uk
9th Ranked


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

Hi Omer,
For a given portal if you wish to move a tab from the admin menu and allow the user group siteadmin to view it do the follow:

select the item on the admin menu you wish to be accesible by the siteadmin.
Once the page has loaded take a note of the tabid in the URL

now select any other normal page on your site and click on settings.

now in the URL replace the number after /tabid/ with the tabid you took a note of earlier

You can now edit the page properties as you would a normal page.
So assign view privileges to the siteadmin group and select a location from parent page e.g. a page called site admin.

That should solve the problem for now.

John


John Nicholson
 
New Post 2/28/2008 12:32 PM
User is offline Bryan Beswick
7 posts
10th Ranked


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

Rather than deleting the records, it would be best to just hide them because it is easy to just turn them back on any time you like.  I used code like this:

UPDATE Tabs
SET IsVisible = 0
WHERE TabId = @myTabId

(Where @myTabId is the unique ID of the menu item you want to hide.)  Be aware that DNN seems to cache this information somewhere so the item on the Admin menu may not actually disappear for 20 minutes or so, even if you force your browser to refresh.

 
New Post 2/28/2008 1:36 PM
User is offline Omer
9 posts
10th Ranked


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

Thanks guys.

If i consider what Bryan is suggesting by hiding the tab in the admin, i sense a flaw. I want the tab to be hidden from the admin in all portals when the administrators are logged in, but available to the superuser account.  If i hide the tab with Bryan's SQL Script, i am afraid it may not be available to me (i.e. Superuser) neither. At the moment of this writing, that is just a gut feeling....but i am willing to try.  If somebody can elaborate on Bryan's SQL script to make it work the way i want, that would be perfect.  Hide any tab i want from the Admin Menu for the administrator roles but still keep available in the admin menu for the superuser account.

 

 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  I need a SQL script to limit access to admin menu --HELP A NEWBIE, PLEASE
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


PartnerPoint | Community of Microsoft Partners
PartnerPoint is one of the largest and most active online communities of Microsoft Partners worlwide with over 8,000 members.
www.PartnerPoint.com
Web Valley
Website design, Database development
www.webvalley.com
UK DotNetNuke CMS installation, hosting & support
UK based installation, branding, customising, integration, hosting, training, support and maintenance services for DotNetNuke
www.deburca.co.uk

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP