Bizarre login behavior.

sql2k
sp3
I have two db's, each with a WINNT login named DBATest. DBATest is a member
of Security Admins as well as db_accessadmin and db_securityadmin in both
DB's. However, in one DB he can see the Users and Roles, and in the other he
cant. How can it be?
TIA, ChrisRIt turned out to be that Public was granted Select on all the System tables
in one DB but not the other. It would seem that if a user was added to
db_accessadmin and db_securityadmin, something like a trigger would make sur
e
the correct systems tables had Select, but oh well.
"ChrisR" wrote:

> sql2k
> sp3
> I have two db's, each with a WINNT login named DBATest. DBATest is a membe
r
> of Security Admins as well as db_accessadmin and db_securityadmin in both
> DB's. However, in one DB he can see the Users and Roles, and in the other
he
> cant. How can it be?
> TIA, ChrisR