On 05/05/15 16:04, Dimitry Sibiryakov wrote: > 05.05.2015 14:38, Alex Peshkoff wrote: >> To be precise - SQL standard was broken when I've added user management >> from SQL in 2.5. >> If one types: >> SQL> create user "Qq" password 'zz'; >> user QQ will be added. > IIRC, grant all to user "Qq" will grant rights to user Qq.
Before writing something it's probably good idea to check? GRANT is compatible with old (do not say good) gsec: SQL> GRANT EXECUTE ON PROCEDURE MAIL_LABEL to user "Qq"; SQL> show grant; /* Grant permissions for this database */ GRANT EXECUTE ON PROCEDURE MAIL_LABEL TO USER QQ SQL> commit; SQL> set list; SQL> select * from rdb$user_privileges where RDB$RELATION_NAME = 'MAIL_LABEL'; // omitted always present SQL-over-GDML-emulation rights RDB$USER QQ RDB$GRANTOR SYSDBA RDB$PRIVILEGE X RDB$GRANT_OPTION 0 RDB$RELATION_NAME MAIL_LABEL RDB$FIELD_NAME <null> RDB$USER_TYPE 8 RDB$OBJECT_TYPE 5 SQL> show version; ISQL Version: LI-V2.5.5.26860 Firebird 2.5 Server version: Firebird/linux AMD64 (access method), version "LI-V2.5.4.26812 Firebird 2.5" on disk structure version 11.2 SQL> ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
