Re: Roles

From: news.microsoft.com (joe_at_msn.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 07:38:36 -0800

This was my solution after first using EM and scripting the SP without current Permissions:

select "grant execute on " + name + " to db_procexecutor_write"
from sysobjects where xtype='P'

"news.microsoft.com" <joe@msn.com> wrote in message news:OMK9S67EFHA.4004@tk2msftngp13.phx.gbl...
> I need to take about 300 SP's and strip out whatever permissions are
> assigned to them - then add one role:
> db_procexecutor_write to each one.
>
> For example - at the bottom of this SP is:
> ....
> go
> GRANT EXECUTE ON dbo.p_CnsAct_i TO WINADMIN
> go
> GRANT EXECUTE ON dbo.p_CnsAct_i TO WINCNS
> go
> GRANT EXECUTE ON dbo.p_CnsAct_i TO WINCNSSUPV
> go
> GRANT EXECUTE ON dbo.p_CnsAct_i TO WINCOMPILEALL
>
> When I'm done - it should only have:
> GRANT EXECUTE ON db_procexecutor_write
>
>

Relevant Pages

  • Re: how to restrict users to search in their own Organizational Unit
    ... candidate for scripting IF the process makes sense at ... If MOSS Admins need to administer users and/or group membership, just create a mmc console and delegate the proper rights for them. ... Now, because you're dealing with many users, my recommendation is to create THE NECESARY Security Groups in each OU and related them with your MOSS2007 existing security groups, in future when someone creates some user, you just have to add that user to the necessary group and that user will be given the necessary permissions. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Creating Multiple FTP Users and Containers (2000 Server + IIS)
    ... > IIS Administrator for an FTP site. ... > complete Windows Scripting novice so I'm hoping that I can get some help ... > What I am even more unsure of is scripting the creation of Virtual Folders ... The permissions will need to be set to ...
    (microsoft.public.windows.server.scripting)
  • Re: Sql permissions headache
    ... By scripting all of your database objects and the permissions ... Knowing which permissions to assign each group is not going to be easy... ... creation (tables, views, stored procs, etc.), I put a GRANT statement to ...
    (microsoft.public.sqlserver.security)
  • Re: Creating Multiple FTP Users and Containers (2000 Server + IIS)
    ... >complete Windows Scripting novice so I’m hoping that I can get some help on ... >What I am even more unsure of is scripting the creation of Virtual Folders ... The permissions will need to be set to ... >account will need to be given ‘modify’ permissions (everything except ‘full ...
    (microsoft.public.windows.server.scripting)
  • Re: xcacls.vbs version 5.1
    ... We use open share permissions and tight NTFS ... Windows XP/Win2k3 computer instead and see if it helps on the speed. ... -- torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway Administration scripting examples and an ONLINE version of the 1328 page Scripting Guide: ...
    (microsoft.public.windows.server.scripting)