On 3/4/21 1:00 PM, Gabor Boros wrote:
Hi All,
In ISQL with a brand new 4.0 database:
SQL> select distinct rdb$user, rdb$user_type from rdb$user_privileges
where rdb$user not in ('SYSDBA','PUBLIC') order by rdb$user;
RDB$USER RDB$USER_TYPE
=============================
22 20
3 20
4 20
Who are they?
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.)
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
