Query related to Proxy user in 10g
In proxy user, based on my understanding, connection through proxy user will have full (object level)rights (select,delete,drop etc.) on the objects owned by main user.
Is there any way to restrict the object level access (on objects owned by main user) for the connections made through proxy user.