| Subject | Re: [firebird-support] Any 'run as' in SQL/PSQL in FB3 ? |
|---|---|
| Author | hamacker |
| Post date | 2017-08-30T19:15:41Z |
Here in fb3, to put role name in execute, Its mandatory put username and password too.
For username I can use current_user to workaround, but password ... there is not current_password to go on...(ha haha )
Well, I will wait for this feature in fb3+.
The intention is do sometihing that current_user or role does not has permition.
In MSSQL, per exemple, I can do this: execute SP_PROC(bla) EXECUTE AS anotheruser, it´s so usefully and avoid spaghetti grant permittion.
I found 'set role' and 'set role thrust' in docs, what is it for? I try to test in block sql code, buts fails.
2017-08-30 13:15 GMT-03:00 Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com>:
30.08.2017 17:58, hamacker sirhamacker@... [firebird-support] wrote:
> To run, I need to know user and password and I don´t.
No, you don't. If you provide role name only, current user will be used.