Post reply

Scheduling a permission level change?

  • December 7, 2007 at 2:00 pm

    #121317

    Currently, a company I'm working for is in the middle of transitioning its members out. I'm looking for a way to schedule a permission level change on a set number of roles from readwrite to readonly, and another set number of roles from readonly to readwrite.

    Any ideas?

    I'm using SQL server 2k.

    if you have any other questions or comments, feel free to post.

  • December 8, 2007 at 2:56 pm

    #758330

    Dominic, you could script out the changes you want to make and place the scripts in a step within a SQL Agent job and schedule it to run at the time/date you desire. Were you looking for the code to do this as well? If so, please give us some more details.

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

  • December 11, 2007 at 9:51 am

    #759045

    thanks for your reply.

    If I can't find the scripts on my own, I'll post a follow up.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply