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
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
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$USERRDB$USER_TYPE
=
22 20
3 20
4