Hello,

It seems the Public role is working fine inside, but other things are
going wrong. The Public role appears under Server Roles. However, the
problem is that when I double click the Public icon (under Server
Roles), the Server Role Properties window should list all the logins
that are members of the Public role. However, none of these logins are
shown.

In addition, all of the stored procedures and functions that I have
tried do not work correctly for all logins. For example:

-- Doesn't work:
sp_srvrolepermission 'public'

-- works for the current login, but not for other logins:
SELECT is_srvrolemember('public')

-- Doesn't work:
SELECT is_srvrolemember('public', 'mary') --

Although the Is_SrvRoleMember function returned 0, meaning that Mary is
not a member of the Public role, I logged in using the Mary login and
succeeded even though Mary doesn't have any user in the database.

So, it seems that the Public role member is working properly internally
but the problem is with the stored procedures and functions that deal
with the server roles. And the second problem is with the SSMS because
it doesn't show the members of the Public role.

Michel


*** Sent via Developersdex http://www.developersdex.com ***