Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Explicit Permissions For Server SQL Server 2005

    Hi All,

    I am looking for a description of all explicit permissions for server. I can't find it anywhere, I checked BOL and the internet without any luck. Any ideas?

  2. #2
    Join Date
    Nov 2005
    Posts
    122
    On SQL Server 2005 there are a few system views and functions that will give you all the information you'll ever need about permissions, roles and principals.

    sys.fn_builtin_permissions(...)
    sys.server_permissions
    sys.server_role_members
    sys.server_principals

    ...just to name some of them.

  3. #3
    Join Date
    Jul 2004
    Posts
    268
    What I am looking for is a full description of the different server permissions, like we get in BOL, except I can't find it in BOL. Example: one of the server permissions is alter any connection and I need to know what it means. I hope this is clear.

  4. #4
    Join Date
    Nov 2005
    Posts
    122
    Quote Originally Posted by inka
    What I am looking for is a full description of the different server permissions, like we get in BOL, except I can't find it in BOL. Example: one of the server permissions is alter any connection and I need to know what it means. I hope this is clear.
    Ok, I see. What you are saying is that BOL does not explain what ALTER ANY CONNECTION means. I haven't found any detailed description either, and I agree that it is hard to guess what some of the permissions actually give you permission to do. Take ALTER ANY CONNECTION as an example. What will it let me do? Kill connections? Create principals (logins and users)? Grant permissions to principals? I must honestly say I don't know for this one.

  5. #5
    Join Date
    Jul 2004
    Posts
    268
    I see. Thanks anyway.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •