database roles

Last Post 04 Nov 2010 04:16 PM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sql-tips
New Member
New Member

--
04 Nov 2010 08:22 AM
I have a database role, right click on properties, go to securables, add all objects belonging to schema for dbo.  it appears all explicit permissions in the list and I click ok. When I reopen my role all disappears no securables and no permissions.
It works fine on other servers, except one db server and have latest sp03. Do I miss any hotfix? Any help appreciated..

gunneyk
New Member
New Member

--
04 Nov 2010 04:16 PM
I am not aware of a bug that would cause that but make sure that the client tools (SSMS) have the latest sp applied and not just the server.


Acceptable Use Policy
---