| Subject | Re: [firebird-support] GRANT/REVOKE are unknown token within stored proc :( |
|---|---|
| Author | Martijn Tonies |
| Post date | 2004-11-22T20:00:02Z |
Hi,
cannot be used in stored procedures or triggers.
If you really really need to use those command, have a look at the
Release Notes and search for EXECUTE STATEMENT.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
>Because GRANT/REVOKE is a DDL command. DDL commands
> Why I can't to use GRANT/REVOKE SQL statement inside of
> code of my stored procedure in FireBird 1.5.1?
cannot be used in stored procedures or triggers.
If you really really need to use those command, have a look at the
Release Notes and search for EXECUTE STATEMENT.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com