I am working on project that has a very simple requirement. I want to allow a User to assign security to other users. The drawback is due to a guideleine that the user may not have permissions to the tables that they need to assign to other users.
I have tried several variation of how to get around this, but still have not been able to resolve this issue. Has anyone attempted this in the Past, and can you please help me with ideas on resolving this problem?
Thanks to everyone who can provide assitance here.