30.08.2017 21:15, hamacker sirhamacker@... [firebird-support] wrote:

> Here in fb3, to put role name in execute, Its mandatory put username and password too.

I was wrong a little, but still you should read the documentation:

> - if ON EXTERNAL DATA SOURCE clause is omitted then
> a) statement will be executed against current (local) database
> b) if AS USER clause is omitted or <user_name> equal to CURRENT_USER
> and if ROLE clause is omitted or <role_name> equal to CURRENT_ROLE
> then the statement is executed in current connection context
> c) if <user_name> is not equal to CURRENT_USER or <role_name> not equal to CURRENT_ROLE
> then the statement is executed in separate connection established inside the same
> engine instance (i.e. created new internal connection without Y-Valve and remote layers).

--
WBR, SD.