Post reply

Looking for Software to automate provisioning of sql logins

  • June 14, 2012 at 10:52 am

    #392526

    We have a need to create that automation of user logins temp_userxxx on a weekly basis. Maintaining these permissions on a weekly basis is a large overhead. Outside of creating a home brew solution, does anyone know of software that does this already?

  • June 14, 2012 at 12:27 pm

    #1501210

    i would probably tackle it with a scheduled job, or in a service broker fired on database restore or database creation.

    it depends on what exactly you are trying to do, of course, but it sounds like you'd build the scripts once, and forget it existed , whether a job or an extended event/DDL trigger.

    if you could identify a little more detail on what you are trying to do, we could help better.

    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!

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

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