Post reply

How to list out the permissions of a database role in SQL Server 2005?

  • October 6, 2006 at 8:16 am

    #174616

    I'm new to SQL Server 2005. It seems the GUI is different that the couterpart of SQL Server 2000. How can I explore the permissions of database roles and users in Management Studio? And more specifically, I have the question in the subject. Thanks!

  • October 6, 2006 at 9:55 am

    #664640

    Hi,

    On Object Explorer select Security and then Logins.

    Select the user you need to check and then, on the rigth side (Summary) rigth click the mouse and choose "property". A new window will appear with the Server Roles associated to the user and other information.

    Choosing Server Roles on the left, rigth clicking the mouse on the summary view and choosing property bring you information about the Roles.

    Did it help you?

    Regards,

    Joao

  • October 6, 2006 at 11:04 am

    #664654

    Thanks Joao,

    This is helpful. Is there any other way, like executing a sql command?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply