November 29, 2006 at 10:46 am
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
November 29, 2006 at 2:49 pm
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
November 30, 2006 at 1:42 am
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