On 05/16/18 09:26, liviuslivius wrote:
Hi,
can you point me if i understand correctly
that if user need to see all data in e.g. mon$attachement
i cannot grant he/se privilege or add this privilege to currently
existed role
You can add this privilege to existing role:
SQL> SHOW ROLE EXISTING;
Role EXISTING is granted to:
KAROL
SQL> ALTER ROLE EXISTING SET SYSTEM PRIVILEGES TO MONITOR_ANY_ATTACHMENT;
SQL> SHOW ROLE EXISTING;
Role EXISTING is granted to:
KAROL
System privileges: MONITOR_ANY_ATTACHMENT
SQL>
------------------------------------------------------------------------------
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
