Workflow Soluiton

 View Only

  • 1.  Has anyone tried creating SQL Server Users in Workflow?

    Posted Feb 20, 2012 06:27 AM

    Dear All,

    Has anyone tried making SQL Server logins and users in Workflow? If so, was it using the SQL Server Stored Procedure Generator and then using a SP to do this?

    The problem is that I need to create users to access a set of Servers with varying levels of security. If I create the 3 Roles on each server with the correct permissions for each Database, then, in theory, should I be able to use an SP (a SYS one built into the Master Database???) to make a login and user with one of the Roles.

    Problem is, I have to revoke the permissions. Is it a reverse of the process?

    Kindest regards,

     

    QuietLeni



  • 2.  RE: Has anyone tried creating SQL Server Users in Workflow?

    Posted Feb 20, 2012 12:36 PM

    reecardo,

    Hmmm. I had not heard of that one. I have only used the Table and Stored Procedure Generators. If I were not upgrading to 7.1 SP1 on my server, I would be in there right now...

    Kindest regards,

    QuietLeni



  • 3.  RE: Has anyone tried creating SQL Server Users in Workflow?
    Best Answer

    Posted Feb 20, 2012 04:34 PM

    You could try just using the SQL query/script generator and using GRANT/REVOKE statements.