Background: We've got a targetsystem which we want to allow access a custom table direclty via SQL (Object-Layer cannot be used due to technical restriction on the targetsystem)
With SQL commands, we've created a DB-Login + DB-User and a DB-Role . The User and Role are both visible in Designer (Base Data - Database Server).
When adding a permission to the Role in Designer (e.g. USER_TABLE CCC_Dummy:DELETE) it has no effect on the DB (User with Role cannot delete entry in CCC_Dummy)
When granting a permission via SQL (e.g. SELECT on CCC_Dummy to Role), User with role is able to query the table. But the granted permission is not displayd in Desginer -yes, we did execcute QBM_PCustomSQLFill Now we have a missmatch between what's visible in Designer and effective on the DB.
Is this expected behaviour or did we miss something?
