Posted by Dan Guzman on 09/29/27 11:33

> Any idea why some of these logins can't see the databases?

I don't have a SQL 7 instance handy but I believe EM uses the HAS_DBACCESS
function to show/hide databases any database listed by the query below
should be listed and available to the user. Conversely, databases not
returned by the query ought not to be listed

SELECT
name
FROM master.dbo.sysdatabases
WHERE has_dbaccess(name) = 1

Since you've already checked system roles, I suggest you check login/user
mapping using sp_helplogins. If incorrect, you can correct using
sp_change_users_login.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Lyle H. Gray" <gray@no.spam.cs.umass.edu.invalid> wrote in message
news:Xns971FCEFBB912Egraynoibisspamcsumas@192.168.1.104...
> Enterprise Manager for MSSQL 2000 (V8.0), connecting to MSSQL 7 database
> server:
>
> Some logins can see the listing of all databases through Enterprise
> Manager, some cannot. Logins are set up as users in the same databases,
> and do not have any special server roles.
>
> If it makes any difference, none of the logins are tied in to the Windows
> logins.
>
> Any idea why some of these logins can't see the databases?
>
> Regards,
> Lyle H. Gray

[Back to original message]