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 [email protected] [firebird-support] <[email protected]>: > > > 30.08.2017 17:58, hamacker [email protected] [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. >
