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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
Execute a stored procedure asynchronously 2
Stored procedure as row source for a combo box 4
OpenStoredProcedure and Parameters 2
Join multiple stored procedure results using query editor ??? 1
Stored procedure recordset not opening 9

Back
Top