Oracle PL/SQL: USERS: Proxy Users - The following statement alters the user "app user1". The example permits app user1 to connect throug

Quick Search:

Oracle PL/SQL: USERS: Proxy Users

Jump to:

Category: >> Oracle PL/SQL >> USERS: Proxy Users

<< last

next >>

Snippet Name: USERS: Proxy Users

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.

Also see:
» USER: connection information
» USER: User Information 2
» USER idle time
» USER Information
» USER active connected users
» USER memory use
» USER: Connected Users
» USER: drop user
» USER: misc queries and commands
» USER system authentication
» USER lock account
» USER password expiration
» USER profile
» USER tablespace quota
» USER temp tablespace
» USER tablespace
» USER password
» USERS: view specific user info
» USERS: view currently connected users
» USERS: view all active users
» USERS: Drop users
» USERS: Lock and Unlock accounts
» USERS: Grant tablespace access
» USERS: Alter a user
» USERS: CREATE USER w/ authentication
» USERS: Creating Users
» CREATE USER
» Drop User example
» Create User example
» Create User

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 09th, 2009

 
ALTER USER app_user1 
   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:
 
ALTER USER app_user1 REVOKE CONNECT THROUGH sh;