2021.03.04. 11:49 keltezéssel, Alex Peshkoff via Firebird-devel írta:

That are grants to system privileges. Normally they are created using GRANT something TO SYSTEM PRIVILEGE name, but some are predefined in database. If you use this SQL:

select distinct RDB$RELATION_NAME, T.RDB$TYPE_NAME from rdb$user_privileges join RDB$TYPES T on T.RDB$FIELD_NAME = 'RDB$SYSTEM_PRIVILEGES' and RDB$USER = T.RDB$TYPE where rdb$user not in ('SYSDBA','PUBLIC') order by rdb$user;

you can see that they are assignments are logical and useful. (In that list privilege is granted full rights to system table RDB$RELATION_NAME.)


Thank you Alex!

Gabor


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to