SQL Server 2005 Effective Permissions

  • Hi,

    I have a couple of problems, which I'm struggling to get my head round:

    1. I have sysadmin rights but when I look at the 'Database Role Properties' page of a role (that I have created) and click on 'Securables', non of the securables that I have set permissions on are displayed. I have used system sp's to confirm the permissions are set for the role.

    2. On all screens the 'Effective Permissions' button is greyed out.

    Any explanation/help with the above would be much appreciated.

    Thanks

    Jon

  • There were a couple of posts on this topic on this forum. I did test it a while ago and have the same result. You can add a securable and set permissions but it would not be displayed. It would be nice to know the explanation.

    But you can query securables permissions by the query similar to this:

    select

    * from sys.database_permissions where grantee_principal_id =10

    just put a number that corresponds your role's UID from sysusers, in this case, my test group ID was 10.

    Regards,Yelena Varsha

  • Hi,

    Thanks for the response. Good to know that i'm not missing something obvious and it may be a bug.

    Jon

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

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