MS SQL Server 2008 R2, Windows Server 2008 R2 Security, Database Administration.
I need a clear guidance in the creation of a database-access for an "external user" (the user) to our SQL database.
The user must be able to connect to the SQL server via the Internet. The SQL Sever is running on a Microsoft SQL Server 2008 R2.
The User is allowed to read only specific tables or views (still to create) of the database.
The user is allowed to access with aditional rights (add, modify and delete records) only to one table of the database.
All other elements (System Databases, Security, Server Objects, Replication and Management) have not to be visible from the remote Microsoft SQL Server Management Studio.
Data privacy and hacker protection is most important for us.
Tasks of the awarded freelancer:
Assistance for the creation of RDA-Access through a TeamViewer session / Skype conference.
Assistance in the completation of the relevant documentation, so as the result can be reproduced at any time.
14 freelancers are bidding on average €107 for this job
This is normally a very simple task and can be done in about a half an hour. Let me know when you'd like to get this done, and I can clear some time on my schedule for a TeamViewer session with you.
Hello I'm a software engineer with good knowledge in sql. I can help you to configure access level for your user. send me p.m for more detail best regards hossein