Re: Viewing default db role permissions

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 04/25/05

  • Next message: Old Fart: "Access problem using computer domain account" 
    Date: Mon, 25 Apr 2005 20:39:31 +0200

    These are fixed roles, the special information shown in the BOL is the only
    one you will see via the GUI. YOu can´t change these roles like those on
    server level.

    HTH, Jens Suessmeyer. 

    ---
http://www.sqlserver2005.de
---
<dkland@cox.net> schrieb im Newsbeitrag 
news:1114454094.312846.302160@f14g2000cwb.googlegroups.com...
> 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
>
  • Next message: Old Fart: "Access problem using computer domain account"