SQL connection and new users
Hi guys,
Just wondering where to change the setting for new users on a SQL connection with integrated security, so they're not administrators by default?
We'd like to avoid adding new users to RDM manually, and avoid new SQL users from being admins by default. Is this possible? The User Template area has User Type set to User.
Also, new users don't seem to be assigned the license from SQL - even though Auto assign new users is checked in the Licenses area of User and Security Management.
Cheers!
All Comments (3)
Hello,
How do you create your users if you don’t create them manually via the Administration - Users menu?
Are you adding them into a specific AD group and this AD group has been added on SQL Server via SSMS?
Best regards,
Jeff Dagenais
Yes thats right. Any user in a particular AD group can login as a new user and appears in the RDM users list - but we then need to manually set these new users as "Users" and assign a license
Hello,
To get a full AD integration which means that you users will be created properly with the proper access based on AD Group + license assignation at the creation, you would need to use Password Server as your backend datasource. It's the only type of data source who's offering you this feature - https://server.devolutions.net/
With SQL Server, the recommendation is to create the users manually to avoid this kind of issues.
Best regards,
Jeff Dagenais