Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    41

    Question Unanswered: Server roles for a login

    How do I find the server roles/privileges granted to the logins as a DBA?

    I would like to know the list of logins which have sa_role or sso_role.

    Thanks
    ====================
    Rajesh

  2. #2
    Join Date
    Jun 2003
    Posts
    140

    Re: Server roles for a login

    Hi,

    select show_role() -> gives all active systemroles for logged in login

    To see roles for all the logins execute following select st.

    SELECT role_name(srid),suser_name(suid)
    FROM master..sysloginroles GROUP BY srid ORDER BY srid

Posting Permissions

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