Public Role in SQL Server 2000 SP3

From: Peter (anonymous_at_discussions.microsoft.com)
Date: 07/13/04


Date: Mon, 12 Jul 2004 21:21:06 -0700

If I add a user to a database with Public Database Role, I
would like to know what privilege has been granted to him.

This is because we find that he is not able to SELECT any
table.