Description: The following statement alters the user "app_user1". The example permits app_user1 to connect through the proxy user sh. The example also allows app_user1 to enable its warehouse_user role when connected through the proxy sh.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 09th, 2009
GRANT CONNECT THROUGH sh
WITH ROLE warehouse_user;-- The following statement takes away the right of -- user app_user1 to connect through the proxy user sh:ALTERUSER app_user1 REVOKE CONNECT THROUGH sh;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.