Stored Procedure and ACCESS

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?
 
S

Sylvain Lafontaine

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?
 
A

aaron.kempf

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
OpenStoredProcedure and Parameters 2
Stored procedure as row source for a combo box 4
Join multiple stored procedure results using query editor ??? 1
Trouble using data from stored procedure for report! 1

Top