[dba-SQLServer] Securables in SQL Server 2005

Dear List,

I hope you can rescue the last of my hair--I've been pulling it out today in large handfuls!

In SQL Server 2000, setting permissions for specific roles to be able to execute specific sprocs was a simple operation--boring, but simple.  You were shown a list of all the objects you might grant or revoke permissions on and you could arrow and space bar through the list.  

In 2005, setting permissions for securables for specific roles is a nasty mouse intensive project.  You're shown a list of available objects, with possible specific permissions in a separate list below.  You select one on the top level, then mouse down to the bottom to click a permission there.  And when you have done it all and click ok, the list vanishes completely.  

Will someone please tell me that I am missing something and that there is an easier way?  And then, also, what the easier way is?  :)  

Thanks so much!
 
Liz





Liz  Doering
612.667.2447 

"This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation"