20.02.2018 12:55, Roman Simakov wrote:
2) We have no check of existance a subjects of privileges. I.e.
SQL> create table t(i integer);
SQL> grant select on t to wrong_func;
SQL> show function wrong_func;
There is no user-defined function WRONG_FUNC in this database

I tend to consider it as a bug to be fixed. Am I right?

Without explicit type of subject GRANT command grants it to a user which existence cannot be verified. You must use explicit "grant select on t to FUNCTION wrong_func" to get error.
  I don't know if in currently user's existence can be checked via SEC$USERS.

--
  WBR, SD.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to