I've tried to grant roles using OracleQuery but..

[Ferk0]

I've tried to grant roles using OracleQuery (The roles sometimes are made of another roles), first of all I generate the sql at runtime.
QRY_GrantRoles.SQL.clear;
QRY_GrantRoles.SQL.Add('GRANT '+VLS_Sql+ ' TO '+ VSS_CurrentUser);
It works well, but when the number of users grows, the app stops at the line where the OracleQuery executes the sql statement. (QRY_GrantRoles.Execute

The app stops at the line but does not send error message, like if the app was waiting for something.

I need to know which are the reasons of it and how to fix it.

Thanks

-------
ferk0
ferk0@yahoo.com

 

[Marco Kalter]

Perhaps you can use the Oracle Monitor to verify if the statement is hanging during execution on the Server?

------------------
Marco Kalter
Allround Automations