SQL Query - run without permissions/direct access
SQL Query - run without permissions/direct access
(OP)
Hi,
One of my users has written several simple SQL queries that he needs run every month against one of our databases. The queries delete, insert and update data and are run in 4 separate groups. My manager has said the user can not have direct login access to the server unless absolutely necessary, so what I would like to know is is it possible for the user to run the queries against the database without having direct access to it and the server?
Due to the nature of the data held on the server, we are restricting all access to only members of the administration team and the user is just a user with no direct access to the server.
Any help would be appreciated.
Kieran
One of my users has written several simple SQL queries that he needs run every month against one of our databases. The queries delete, insert and update data and are run in 4 separate groups. My manager has said the user can not have direct login access to the server unless absolutely necessary, so what I would like to know is is it possible for the user to run the queries against the database without having direct access to it and the server?
Due to the nature of the data held on the server, we are restricting all access to only members of the administration team and the user is just a user with no direct access to the server.
Any help would be appreciated.
Kieran
Talk To Other Members
RE: SQL Query - run without permissions/direct access
Regards
Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?