user of the stored procedure

Database
Enthusiast

user of the stored procedure

Dear experts,

i am looking for a 'command', that inside the stored procedure defines the 'current' user.
The problem is, that in the actual case the user will be automatically the current database. This is bad for the follow up tasks. We could certainly define all used database as user, but i want to have another solution - if any exists...

1 REPLY
Enthusiast

Re: user of the stored procedure

Dear all,

we have already one solution:
grant select, insert, update, delete on with grant option
Certainly, any other (i.e. set user of a stored procedure) solution is very welcome!