Stored Procedure and ACCESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need some assistance

I need a way to execute a stored procedure (truncate table) but unfor. user
cannot execute it due to having user restriction. Is there a way that a
username that can execute be hardcoded and after the stored procedure been
execute, bring the username back to the original username?
 
The closest thing to this would be to use a Role Application inside a SP;
however I'm not sure if it's worth it.

If you want the user to execute this SP, why don't you give him the
permission to do so?
 
yes, if you use ADP you should be able to use 'SETUSER' i believe is
the name of it.

this isn't possible under MDB; since MDB doesn't keep the connection
open.

-Aaron
 
Back
Top