any documentation for default.xml keywords/switches - Support Queries

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » any documentation for default.xml keywords/switches

any documentation for default.xml keywords/switches

Options · View

Previous Topic · Next Topic

nigeldh

Posted: Thursday, July 03, 2008 2:52:29 PM

Rank: Member
Groups: Member

Joined: 7/2/2008
Posts: 5
Points: 0
Location: nr. Ithaca, NY

Is there any documentation for default.xml keywords/switches.
Similar to a man page.

Since our client wants their configuration to be locked down, I guess I can start with just the management section.

<management>
<errorlog display="true" />
<activitymonitor display="true" />
</management>

thanks, Nigel
"Jim, I'm an SA not a DBA" [apologies to Star Trek fans]

elian

Posted: Thursday, July 03, 2008 3:21:24 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

Quote:

ENABLING/DISABLING FEATURES

Each feature of myLittleAdmin can be enabled/disabled. Please follow the instructions below:
1. Feature settings are located in the xml/profile/default.xml file. Edit the xml/profile/default.xml.
2. Set to true or false the feature you want to enable or disable.
3. Relaunch myLittleAdmin

Remarks :
· System Database: In order to disable the possibility to list System databases, you need to edit the xml/ treeviewdatabase.xml file and to remove the D10 node
· Security: In order to disable the possibility to list Logins / Server roles / Credentials, you need to edit the xml/ treeviewsecurity.xml file and to remove the selected node.
· Server Objects section: In order to disable the possibility to list Backup Devices / Linked servers / Triggers, you need to edit the xml/ treeviewserverobjects.xml file and to remove the selected node.

nigeldh

Posted: Thursday, July 03, 2008 4:14:44 PM

Rank: Member
Groups: Member

Joined: 7/2/2008
Posts: 5
Points: 0
Location: nr. Ithaca, NY

thanks, I did see that post. Nigel
myLittleTools Community Forum » myLittleAdmin For SQL Server 2005 » Support Queries » System Databases
and
myLittleTools Community Forum » myLittleAdmin For SQL Server 2005 » Support Queries » Hide myLittleBackup

elian

Posted: Thursday, July 03, 2008 4:22:38 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

If you want to completly remove the "Management" tab, then you can edit file /xml/navbardata.xml
and remove the
<parent id="navbarManagement" title="Management" loctitle="lManagement">
full node.

nigeldh

Posted: Thursday, July 03, 2008 6:51:59 PM

Rank: Member
Groups: Member

Joined: 7/2/2008
Posts: 5
Points: 0
Location: nr. Ithaca, NY

Thanks Elian. That is what we did.

For folks who need to modify or limit access to their SQL servers through mySQL. Here are the steps we did.

1. Start at the top with navbardata.xml, [install directory]\xml, and comment out the sections and subsections that you don't need. XML comments use  and can span multiple lines.
This changes the display, menu, on the left to just what you want/need folks to see.

2. Certain sections like Databases reference an external treeview file such as treeviewdatabase.xml. (in [install directory]\xml)
In this treeview file comment out unneeded sections
i.e. node id="D10" etc. in treeviewdatabase.xml.

3. Use default.xml, [install directory]\xml\profiles, to tweak the final settings, granularity, access. Change true to false to deny access to a particular operation
i.e. <databases create="false" rename="false" drop="false">
<tables display="true" create="false" ....
will allow myLittleAdmin users to just browse the database and tables.

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » any documentation for default.xml keywords/switches

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.