[dba-SQLServer] Securables in SQL Server 2005

Francisco,

Thanks so much for replying.  I actually came to the same solution.  

Since, however, I had hundreds to set--and a bunch to unset--I created a
table with all the objects and who needed permissions on each one.  Then
I built up all my Grant and Revoke statements in a query, pasted the
results in a new query window and ran them all at once.  I'm sure there
were more elegant solutions, but this one did save my fingers--and my
hair!

Thanks,
 
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"

 
 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com 
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
Of Francisco Tapia
Sent: Thursday, March 15, 2007 4:34 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Securables in SQL Server 2005

Elizabeth,
  Sorry for not replying before... I've been really busy for the last
2 months... I didn't see anyone reply to your message either.  
I have opted to set permissions using the query window now, 
this saves me on having to exercise my mouse hand.

Generally it looks something like this:

GRANT SELECT, INSERT, UPDATE ON vw_SomeView TO SomeRole


On 2/7/07, Elizabeth.J.Doering at wellsfargo.com
<Elizabeth.J.Doering at wellsfargo.com> wrote:
>
> 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"
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


--
-Francisco
http://sqlthis.blogspot.com | Tsql and More...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com