myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

hide logins Options · View
robert
Posted: Friday, May 16, 2008 2:57:50 AM
Rank: Member
Groups: Member

Joined: 5/16/2008
Posts: 5
Points: 0
When I logon to mylittleadmin for mssql 2000 with a regular user. I am able to click on the logins folder and view all the logins and default database.
How do I disable this?

thank you
elian
Posted: Friday, May 16, 2008 9:54:06 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
The commercial version allows enabling/disabling each feature. But the lite edition doesn't.

Then you need to edit file scripts/inc/tree_con.asp and remove (or comment) line 55.
robert
Posted: Friday, May 16, 2008 6:02:31 PM
Rank: Member
Groups: Member

Joined: 5/16/2008
Posts: 5
Points: 0
Hi
Thanx for your reply. Seems like the issue lies with SQL 2000 as i can view the logins using enterprise manages as well. Is there something on the server that i can disable? Or something I have done wrong on the server?
I just want to make sure before I buy the commercial version.
Security >> logins (so your saying that I can hide all users here right)

thanx again
elian
Posted: Friday, May 16, 2008 6:08:53 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Yes, Enterprise Manager has the same behavior. It was the MS's choice to let this info available. That's why myLittleAdmin also displays it.
Just for info, that has changed with SQL2005. Only sa and the current login are displayed.

In the commercial version, you'll be able to completly hide the "Logins" section by editing the mla_sql_cfg.asp file.

robert
Posted: Friday, May 16, 2008 7:51:21 PM
Rank: Member
Groups: Member

Joined: 5/16/2008
Posts: 5
Points: 0
Excellent !! thanx for your help. Will try the commercial version.
robert
Posted: Friday, May 16, 2008 9:54:12 PM
Rank: Member
Groups: Member

Joined: 5/16/2008
Posts: 5
Points: 0
Sorry if this is a stupid question. Are we able to create tables with this tool? The lite version doesn't have this option and the live demo also doesn't give me an option, unless im missing something.
elian
Posted: Saturday, May 17, 2008 6:10:22 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Display the table list.
Then click on the new table icon . This icon is
located at the top of the list, in the right corner.
Users browsing this topic
Guest


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.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.