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/19/2008 1:44 PM
 

Dear community,

I am excited. 2 months ago, i didn't know anything (zero) about asp.net and dnn. I learnt so much.

I am setting up a website that will allow site users to create their own portals. I am using Portal Signup Module that gives me the option of making the user an admin or non-admin. I decided to still make the user who created the portal the admin (cuz that is easier as i understand it) but limit his/her access to certain admin menu (for instance i want to remove "Site Log" and "Event Viewer" and "Skins") depending on the level of membership.

I read somewhere that the "superuser" has a Role ID of -2 and i am assume that the "admin" has probably a Role ID too. I read also that i can run a SQL script to to modify permissions, Roles, or whatever in the db table. Having mastered from the "clickable" stuff within dnn, this is where i want to play with now. I know some of you may say "if you are not a programmer, don't mess with the db tables"....but i learnt a lot these couple of weeks by pushing the envelope.

I want one of your genuises to give me a script that i can run from "host" -->SQL page within DNN that will allow me to hide or remove "Site Log" or "Event Viewer" from the admin menu for example. But only when the admin is logged. I still want to see those when i (as a superuser) am logged in.

 

Another option someone suggested was for me to make the new users non-admin and put them in a role i defined. That is not a problem. I can create the "portal owners" role. But then, i don't know how to put some of the admin menu (i.e. Site Settings, Security Roles, Vendors, Newsletters...or whatever i decided to allow) into this new role i created "Portal Owners"

I hope i made myself clear as i am someone who just started getting his feet wet few weeks ago.

 

thanks in advance.

 

 

 
New Post
2/19/2008 4:25 PM
 

Hello Community,

It is me again. Since I posted the above question requesting someone to help me with a SQL to remove options from the admin, i digged out a script from the web.

I executed the following script. with a "Run as a script" checked.

It says the "query completed successfuly"  But i can still see the "Site Log" on the admin menu. What is going.

Here is the SQL script i run:

declare @SiteLogTabId int
declare @portalId int

set @portalId = 0;

select @SiteLogTabId=tabId from {objectQualifier}tabs where portalId=@portalId and tabName='Site Log' and tabPath='//Admin//Site Log'

delete from {objectQualifier}tabpermission where tabId=@SiteLogTabId
delete from {objectQualifier}tabs where tabId=@SiteLogTabId

 

The "Site Log" option in admin menu is still there when i am logged in as the admin created when installing dnn and also when i am logged as a superuser.

Can somebody tell me why the SQL query was successful but nothing changed.

 
New Post
2/20/2008 4:43 AM
 

I would suggest that a better option would be to create a new user group and a menu section for them so if you don't want the 'admin' user to have access to everything. Create a menu called site admin adding into that menu the items that you want to allow them to access. I believe that dnn creative has a tutorial on this somewhere.

It wouold make more sense to do this to me as if you make a mistake with the siteadmin group you still have the admin group to work from.


John Nicholson
 
New Post
2/20/2008 10:09 AM
 

I thank you for taking the time to respond.

I appreciate your suggestion and would like to consider it as it makes sense.

My only problem would be to figure how to i can add the menu options to this new user group.

Say i creat a user group "Site Admin". I would like to add the "Site Settings", "File Manager", "Newsletter"...etc....to this Tab.   Just like it is with the current admin tab but with some flexibility for me to control which options i want to give in the menu.

I knwo dnncreative has all kind of good stuff. But at the moment, i am short on budget and i only need to solve this case.

Would you know how i can add the admin menu to a newly created tab?   Any help that can point me to the right direction will be appreciated.

 
New Post
2/21/2008 1:41 PM
 

Please Help on the above issue.

I am still waiting for an answer i can accept from the community.

Either how to remove some options from the "admin menu" using a SQL script. I run the above script to remove the "Site Log", but it still shows up on the admin even though the script was executed successfully.

or How to add some admin menu to a newly created page available to a defined user group (say Portal Owners). The idea is to allow users create their own portal but not give them full admin access.

 

thanks a lot......waiting....waiting...waiting.....hoping some of the dnn experts will help me

 
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