Snippet Name: USER: connection information Description: User connection information from gv_$session_connect_info. Also see:» 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: Proxy Users » 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 10th, 2009
Description: User connection information from gv_$session_connect_info.
Also see:» 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: Proxy Users » 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
SELECT sid, authentication_type, osuser, network_service_banner FROM gv_$session_connect_info;