Home Forums SQL Server 2005 SQL Server 2005 General Discussion Needed database level permissions script for whole instance RE: Needed database level permissions script for whole instance

  • September 10, 2012 at 11:21 am

    #1535841

    johnnyrmtl (9/10/2012)

    Thanks for that and it does indeed work on a sole database at a time.

    I would need it to run from master and get all databases

    you would jsut wrap it with exec sp_msForEachDb and paramterize the databases right? sys.objects becomes ?.sys.objects, etc etc to get teh database context.

    i know it's easy for me to do, but did you try that yet? learning to adapt the code you are going to use is going to be invaluable to you. you are the one who has to maintain the code after you've copied it from here.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!