I created a remote connection from my database here at work so that I can access from home just by entering the company's fixed IP. Now I need to know if it is possible, for example: I have several users created, but I want only the user "query" to be able to connect to the bank externally.
My DB information:
Main database (work): Microsoft SQL Server 2016 (with Management)
Microsoft SQL Server Management Studio 2008
If this possibility exists, could you guide me how?
Complementing:
To better explain, in the case here in the company, we use Management Studio. Let's say that from my house I have the same program (no bank, only Management) and at the time the program requests the server name, username and password I would put FIXED IP, PORT (example: 255.255.255.255, 3333) from company.
I know all the users I have available for login, but I want only the user to be accepted on this type of connection and that other users are blocked unless I have local access.