Rank: Newbie
Groups: Member
Joined: 5/8/2008
Posts: 4
Points: 0
Location: Canada
|
Just wondering why a basic user can see the System Databases. Is there a way to turn that off?
|
Rank: Newbie
Groups: Member
Joined: 5/8/2008
Posts: 4
Points: 0
Location: Canada
|
Also, that same basic user can see and manage the SA account... can that be turned off also?
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
About the sa account:
It is listed for info only and of course cannot be modified or updated by anyone but the sa account himself.
About hiding system dbs:
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.
|