public role membership

why does
sp_helprolemember 'public'
show no results, even though through the gui you can see that all the users
have tat role?Jason,
Since 'public' is defined to always contain everyone with access to a
database, there is no specific assignment to make them role members. So
sp_helprolemember has no rows to read and report on.
FWIW, if I assign a Windows Group to be a role member, only the Windows
Group (but not the logins that are members of the Windows Group) are
reported on by sp_helprolemember.
RLF
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:FADD06B3-9D06-4930-93B0-4CA7C26B1A1F@.microsoft.com...
> why does
> sp_helprolemember 'public'
> show no results, even though through the gui you can see that all the
> users
> have tat role?|||thank you
"Russell Fields" wrote:
> Jason,
> Since 'public' is defined to always contain everyone with access to a
> database, there is no specific assignment to make them role members. So
> sp_helprolemember has no rows to read and report on.
> FWIW, if I assign a Windows Group to be a role member, only the Windows
> Group (but not the logins that are members of the Windows Group) are
> reported on by sp_helprolemember.
> RLF
> "Jason" <Jason@.discussions.microsoft.com> wrote in message
> news:FADD06B3-9D06-4930-93B0-4CA7C26B1A1F@.microsoft.com...
> > why does
> >
> > sp_helprolemember 'public'
> >
> > show no results, even though through the gui you can see that all the
> > users
> > have tat role?
>
>