Subject Grant role by script
Author

Hello,


Using FlameRobin, I can run this statement

GRANT rdb$admin TO USER MyUser;

However, I can't seem to run it in a script. I have a master script file that runs a set of files. I tried it in a file, and directly

1) %SqlExe% -user '%Usr%' -password '%Pwd%' -input ..\Tables\aaaGrant.sql -echo -output %OutFile%


2) %SqlExe% -user %Usr% -password %Pwd% GRANT rdb$admin TO USER LegacyUser;

Is there a way to do this by script?


Thanks