Which users have rights to select from table

[Антон Александров]

Hi,

I know how to see the right, granted to user or role, or procedure to select from specific table.

But how can I see the opposite? I don't know how to check which users or roles or procedures  have rights to select from specific table 

Please help

[Mark Rotteveel]

You can query the RDB$USER_PRIVILEGES table, see also
https://www.firebirdsql.org/file/documentation/html/en/refdocs/fblangref40/firebird-40-language-reference.html#fblangref-appx04-userprivs

Mark
--
Mark Rotteveel

[Антон Александров]

Very Tanks

[Dimitry Sibiryakov]

Антон Александров wrote 30.08.2022 13:01:
> I don't know how to check which users or roles or procedures  have rights to
> select from specific table

isql SHOW GRANTS command can help you:
https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/isql/firebird-isql.html#isql-show-grants

--
WBR, SD.

[Антон Александров]

Thank you, but I prefer to use

select * from RDB$USER_PRIVILEGES

where
 (rdb$relation_name = 'MyTableName')
 and (rdb$privilege = 'S')