Subject | Grant role by script |
---|---|
Author | |
Post date | 2016-05-20T17:58:30Z |
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