Temporarily grant permissions

[Carol Giannini]

I have a secured database used by four offices, three of them in outlying
areas with their own local networks. When I distribute a new front end, I
need the three outlyers to be able to run a procedure that deletes the
existing links (because the new front end comes from me, with invalid links
to the tables on my network) and relinks to the back end tables on their own
networks. But I have set security so that users normally can't do this. Is
it possible to use the Grant and Revoke processes to allow the current user
temporary permission to add tables to the database, then revoke it at the
conclusion of the process? Is this an okay way to do this, or is there a
better way? And finally, does anyone know the exact syntax of the
Grant/Revoke statements? Help isn't particularly helpful on this. I'm
trying to work through the debugging errors (!) but wouldn't mind some
advice, especially if I'm barking up the wrong tree. TIA.

 

[Carol Giannini]

Replying to my own question: I think this is a SQL function? And I'm not
working in SQL, so I guess I'm back to the drawing board.

 

[Lynn Trapp]

Carol,
I've never actually done it, but I believe all you would need to do is
temporarily add the user to the Admins Group and then remove the user from
it after your procedure is finished.