Granting EXEC for read only SPs

Is there any way to grant EXEC on all SPs to a user or role where the SPs
don't modify user tables?

I created database role 'X' and granted EXEC permission for all SPs. Then,
I created a database user, added it to the role 'X' to inherit the EXEC
permissions, AND ALSO added the user to the fixed database role
'denydatawriter'.

I was hoping this scenrio would lead to a run-time error when the SPs that
modify data were invoked. Instead, all SPs execute successfully, including
the ones that modify data. Any workaound to accomplish this? TIA.


.

Relevant Pages

  • Re: Global Customization - Top Nav Bar
    ... Yeah, you know, I read a lot about customizing Onet.xml ... the problem is that the SPS site has expanded ... I have to find a manually way to modify the ... >>I am able to easily modify the Navigation Bar on my ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Anzeige von SPs in Access-adp
    ... > Hat man in einem Access-Projekt nur die Möglichkeit SPs, ... > bzw deren Datenrückgabe in einem Formular anzuzeigen? ... > EXEC ... > View und darin ein Exec auszuführen, ...
    (microsoft.public.de.access)
  • Anzeige von SPs in Access-adp
    ... Access-Projekt per Formular anzeigen zu lassen. ... Hat man in einem Access-Projekt nur die Möglichkeit SPs, ... Ich habe getestet SPs mit recordsource und exec über ein ...
    (microsoft.public.de.access)
  • Re: problems branding SPS 2003...
    ... This is the newsgroup for the CAML language as used in STS 1.0 ... > I've been following the infor on how to brand SPS ... > to modify the rest of the pages as it says to do in the above documents... ...
    (microsoft.public.sharepoint.teamservices.caml)
  • Re: SPS2003 - Customize MySite Default
    ... I was able to modify the shared view for ... > domain admin in NT) and he can still edit the shared view. ... > rights defined in site settings. ... SPS gives all Domain admins SPS admin rights. ...
    (microsoft.public.sharepoint.portalserver)