Viewing default db role permissions

dkland_at_cox.net
Date: 04/25/05 

Date: 25 Apr 2005 11:34:54 -0700

I'm pretty new to SQL Server 2000 and am still fumbling around in
Enterprise Manager. My question is about viewing permissions.

Whenever you create a new user or role you are allowed to specify
whether that user or role has access to various objects in the database
such as tables and stored procedures. I normally do this by opening up
the database in Enterprise Manager, going to the "Role" tree item,
double clicking a role, and clicking the "Permissions..." button at the
top right of the dialog box that pops up. You get a big grid with green
checkmarks representing what the role/user has access to and red X's
representing what they are denied access to.

However, if I try to view this data for one of the default database
roles (like db_owner or db_datawriter) the "Permissions..." button is
greyed out so I can't access the grid mentioned above. Am I doing
something wrong or what? I know you can get a listing of the
permissions of each of these roles from the SQL Server documentation,
but isn't there a way to view it in Enterprise Manager?

Thanks,
Dave