M
makthar
Guest
Hi Stefan, I looked at this problem and I have following observations. 1. When I ran the revoke command on multiple users for multiple tables, I too observed that, sqlexp is taking significant amount of time to complete the execution. Is it possible for you to create an RFA, so that we can spend some time to understand the reason behind slow execution. This should not be this slow!! 2. Revoke command takes locks on certain system tables (like, "_db", "_systabauth") which are also used by ABL, because of which ABL users are not able to login when revoke is executing. This is expected. 3. >> And on the top I am missing more general Rules in the sql access, like DataReader, this would reduce the amount of command for sqlexp. Are you talking about SQL Roles? if that is the case, SQL does not have such capability as you know. If you are mentioning about something else, can you please explain little more about this? Please let me know if you have any questions. Thanks, Akthar.
Continue reading...
Continue reading...