IgorValchenko comments

Repositories
Issues
Comments

Results 2 comments of


                                            IgorValchenko

After deleting tables, we observe residues in the RDB$USER_PRIVILEGES and RDB$SECURITY_CLASSES tables, which leads to an increase in the database with frequent creation and deletion of external tables. Played on Firebird 3-4-5.

shows "dead" privileges on domains SELECT * FROM RDB$USER_PRIVILEGES P WHERE P.RDB$PRIVILEGE = 'G' AND P.RDB$OBJECT_TYPE = 9 AND NOT EXISTS(SELECT * FROM RDB$FIELDS F WHERE F.RDB$FIELD_NAME = P.RDB$RELATION_NAME) RDB$USER...

Incorrect example in the instructions for instsvc

ок!