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
2/21/2008 8:43 PM
 

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 11:27 PM
 

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 8:09 AM
 

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 3:32 PM
 

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 4:36 PM
 

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
 
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