SQL users and groups howto?
hi!
i've set up a sql data source using "integrated security" - then i created a user and a group.
creating a new session/connection with the security group does not seem to have the effect of beeing hidden to other users.
how can this be done?
in the post Migration from Standard to Enterprise you wrote:
i don't understand how to do this.
thanks for your reply.
All Comments (3)
Hi,
For now, you can connect with the Integrated Security, but it's not possible to add a "integrated security" user in RDM. This is why you see all the sessions. You must create a SQL Server user to use the secuirty management. I'm planning to add the integrated security support for the version 5.7, maybe the 5.6, it's a question of time.
David Hervieux
Devolutions inc.
David Hervieux
hi,
so how can i connect to rdm with a user?
thanks.
You'r SQL Server must be installed in mixed mode authentification, after that you can go in RDM and create new user, this will create login and user in SQL Server. After the you can use these users to connect in RDM. You will be able to assign security right.
The new version support integrated security. Let me know if you have a specific question. I will try to produce a more detailed document soon,
David Hervieux
Devolutions inc.
David Hervieux