Subject Access permissions and stored procedures
Author Jay Johannes
A table has full permissions for admin but reference only for users

A stored procedure called by users needs to access above table.
I get a permission access problem here.

Is there a way to login as a different user from within a stored
procedure to access above table?

Or could I tell inside a procedure that I am actually admin who
created the procedure in the first place anyway?

Cheers

Johannes