Re: Get List of users in a sql server role

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/24/05

  • Next message: kitty28: "How to create trigger on view?" 
    Date: Sat, 25 Jun 2005 00:10:57 +0530

    Hi,

    List of roles available in a database:-

    EXEC sp_helprole

    List the members in a role

    sp_helprolemember

    List the members inside a server fixed role:-

    sp_helpsrvrolemember <Rolename>

    Thanks
    Hari
    SQL Server MVP

    "Venkat" <tammana@inooga.com> wrote in message
    news:%23jY3dVMeFHA.3724@TK2MSFTNGP14.phx.gbl...
    > Can any one tell me the way to get the list of members
    > available in a particular database role? I need to get the list of roles
    > available in the database and the list of users available under each role.
    >
    > Can any one give me T-Sql statements to meet my requirement?
    >
    >
    >
    > Thanks in advance.
    >
    >
    >
    > --
    >
    > Venkat
    >
    >
    >
    >
    >
    >
    >

  • Next message: kitty28: "How to create trigger on view?"

    Relevant Pages

    • Re: how does an exec meeting work?
      ... The exec should be very very keen on you attending. ... The Group Scout Council is the electoral body, ... Group Scout Fellowship members; ... the maintenance of the Group's property and equipment; ...
      (uk.rec.scouting)
    • Re: System Administrator Implied Permissions
      ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
      (microsoft.public.sqlserver.security)
    • Re: problems with leaders - advice appreciated
      ... >>> Go check your constitution regarding the position of your Exec members. ... The chairman has no more say in fiscal matters than ... I do believe it because that is how an effective committee works. ...
      (uk.rec.scouting)
    • Re: Big problem fetching members from dynamically loaded module
      ... > make your program harder to understand and more likely to fail in obscure ... and I want their members in the menus if they are installed. ... > to ensure that evaland exec share the same namespace. ...
      (comp.lang.python)
    • Re: Membership of a user in a role
      ... role - e.g. exec sp_helprolemember 'Database Role' ... >grant certain users access to certain members of an entity. ... >DB-Role) he is supposed to possess. ... >be able to verify this before a row is inserted in the ...
      (microsoft.public.sqlserver.security)