Re: Server roles

Tx for a quick answer, but that was not right.

BOL says "Contains a row for each member of a database role" about
sysmembers.

I want server roles (ie securityadmin). I should have told you it's
sql2005 sp2.

/Peter

On Mon, 23 Jun 2008 13:40:07 +0300, "Uri Dimant" <urid@xxxxxxxxxxx>
wrotc:

SELECT *
FROM sysmembers membs
JOIN sysusers users on membs.memberuid = users.uid
JOIN sysusers groups on membs.groupuid = groups.uid



"Peter Lindberg" <plTAKE@xxxxxxxxx> wrote in message
news:485f6dcb.11777531@xxxxxxxxxxxxxxxxxxxxxxx
I have an old master database, I can restore it with another name but
it can't replace the real master.

Is there any way I can se the info about server roles from this
database? I want to se which "role members" there is for different
server roles?

/Peter


.

Relevant Pages

  • Re: Read/Only access to Northwind database
    ... A "fixed database role" is one that is there by default and cannot be ... you cannot create server roles. ... Add the login as a user to the Northwind database ...
    (microsoft.public.sqlserver.security)
  • server roles
    ... I am reading about the server roles, and it is said, they have a "level". ... But do they have a hirarchical level in that way, that a if a member is into ... I.e. a member of "serveradmin" has also the permissions of the group ... Furthermore, and why I am asking, is: If I start the index tuning wizard, I get the message "you need to be a member of sysadmin". ...
    (microsoft.public.sqlserver.security)
  • Re: new userID can do all...
    ... > No server roles have been assigned. ... Does he have administrative rights to the box (including being a member ... of Domain Admins)? ...
    (microsoft.public.sqlserver.security)