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