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 ...Delete SQL tabDelete SQL tab
Previous
 
Next
New Post
6/2/2006 10:30 AM
 
Hi all,

I am wondering if it is an easy task to remove the SQL tab from the host functions. I would need to do this as we do not want even host administrators to be able to make changes directly on the database as we want to maintain tight controls on the database and have a system for documenting such changes which require a backup to be made first.

How would I go about deleting the SQL tab and also any other associated files from the DNN installation?

Many thanks in advance,

John.
 
New Post
6/2/2006 12:50 PM
 

as far as I remember theres no easy way as the host tabs are automatically added during installation (unlike portal admin tabs which are template controlled). You can manually remove the entry in the database i.e.

delete from tabs where tabname='sql'

the control for the sql can be found @ admin\Portal\SQL.ascx , you can delete it (as well as it's .vb and  .resx files), if you want to clean up after it.

Finally, you could also tweak the 01.00.00.SqlDataProvider and DotNetNuke.Data.SqlDataProvider files in Providers\DataProviders\SqlDataProvider and remove the line that add's it in i.e.

"INSERT INTO [dbo].[ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopSrc], [MobileSrc], [AdminOrder], [EditSrc], [Secure]) VALUES (65, 'SQL', 'Admin/Portal/SQL.ascx', NULL, -1, '', 1)"


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
6/5/2006 7:23 AM
 
Thanks Cathal,

Am I right in thinking that I would also need to perform this procedure following an upgrade?...
 
New Post
6/5/2006 8:11 AM
 

no, it's part of the initialisation of your primary portal, so you would not have to re-do any sql steps. However, after an upgrade, the files would be replaced, so you would need to remove them again if you want to clean up properly.

Cathal


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Delete SQL tabDelete SQL tab


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