myLittleTools Community Forum

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

Not admin user - multiple databases - not viewable Options · View
Nstuff
Posted: Monday, August 06, 2007 1:37:02 PM
Rank: Newbie
Groups: Member

Joined: 8/6/2007
Posts: 2
Points: 0
Location: Amsterdam
Hello,

We are using version 2.7 for MSSQL 2000 already, and I am looking for this version as well to support MSSQL 2005 for our customers as well. I am now testing the trial version, to find out all details, and I found something strange, something I can't figure out how this works.

I have 1 user, who owns about 7 databases. Of all these databases he is owner. And in the privileges page he has access and is dbowner of all databases. However I am only able to see the default database in the database list when I login as this user.

Is there something I miss? Or is there another way to enable this?

When I login as 'SA' I don't seem to have this problem, and I am able to see all databases listed.

Thanks for the assistance.
Regards,
Nstuff
elian
Posted: Monday, August 06, 2007 1:57:58 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Thanks to your message, we just found a bug.
A patch will be soon available.

As a work-around before the patch availability, could you please set your user default database to master

Thanks.

Note for the other readers: this error only occurs with version 3.1f
Nstuff
Posted: Monday, August 06, 2007 2:18:34 PM
Rank: Newbie
Groups: Member

Joined: 8/6/2007
Posts: 2
Points: 0
Location: Amsterdam
Thanks, indeed it works with changing the default database to master.

Thanks for the quick response.
elian
Posted: Monday, August 06, 2007 2:22:45 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Thanks for keeping us informed.
The patch should be available very soon.
elian
Posted: Friday, August 10, 2007 1:37:02 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Nstuff wrote:
Thanks, indeed it works with changing the default database to master.

Thanks for the quick response.


As promised, a corrected version is now available. More info
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.