Home Forums Microsoft Access Microsoft Access Access 2003 ADP runs SQL 2005 SP to selectively delete rows - does not remove any rows RE: Access 2003 ADP runs SQL 2005 SP to selectively delete rows - does not remove any rows

  • Sorry, I should have been more specific.

    I write/re-use a T-SQL script eg

    grant execute on sp_SomeName to A_App_SecurityGroup

    If the database only has a small number of objects I'll often just write a script including all the objects and the relevant permissions which I wish to provide. For larger databases I'll use the built-in system views such as sys.objects to provide a list of objects of a specific type.

    These scripts can be as simple or as complex as you wish. Using the system views is a great way to build a script which can be re-used - particularly useful if your database is still maturing.

    If you google for examples, you'll find hundreds. But if you do a search here on SQLServerCentral and specify the scripts option I think you'll find plenty of food for thought.

    If you can't find anything suitable let me know and I'll dig one out for you.

    Cheers