Grant Select problem

S

sebouh181

New Member
Dear All,
need to ask your opinion about an issue.

i have to GRANT SELECT for a specific user.

But one of my clients are far from us, and i dont want to give them "sysprogress" user to do the job.
remote access or citrix or this kind of access to their servers is out of the story since their policy doesnt allow us.

so does anyone know a way? like writing the grant statement in procedure editor and send it as a patch or even a batch?

Thank you
 
You can script SQL but you will still need to provide the password in some way. You might embed it in the script but it would still be there.
 
You may consider to make them install some remote access software to let you login.
Something like VNC, or maybe you can use Remote Desktop.
This if they are somehow "reachable" on the wan.

So you can login and perform your operations.

Pay attention on what you do to do not expose them on attacks while they're "on the net".
 
If I understand your question ... sometimes a big if ... why don't you just create a user for the purpose and grant it only those privileges necessary and appropriate for the task. I usually define a generic user for any SQL application like Actuate or Enterprise Architect and use it for all connections by that application, but if you want to tailor things more specifically, e.g., especially for this remote user, then just define a user for the purpose.
 
You must log in or register to reply here.
Back
Top