Create SQL login and User afterwards

Create SQL login and User afterwards

avatar

Hi,

Is it possible to create a "SQL server login and user" after a user has been created without one?

Thanks

All Comments (1)

avatar

At the moment it is not supported, you will need to do this manually. Something like:

use master;
GO

create login name with password='mypassword';
GO

use rdm;
GO

create user [name] FOR LOGIN [name];
GOI've added a feature request to allow doing this directly within the app.

Best regards,

Stéfane Lavergne