Quick Search:
 Oracle PL/SQL: Switch User Jump to:  
Category: >> Oracle PL/SQL >> Switch User  

<< lastnext >>

Snippet Name: Switch User

Description: Lets you switch from one database user to another (local database only).

Requires ALTER USER and SELECT ON DBA_USERS privileges

Syntax: @su

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» Database Links: CURRENT_USER
» Instant Test Database with DCBA
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
» List security related profile informat...
» Find users with deadly privileges
» Audit User Logins (User Login Trigger)
» Block TOAD and other tools
» Kill Session
» Extents
» DBA Users
» DBA Tablespaces
» DBA triggers
» DBA Sessions
» DBA Roles
» DBA Objects
» DBA Links
» DBA Jobs
» Job Queue
» DBA Free Space
» Data Files

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 27th, 2009

SET termout off head off
col nl newline
spool su.tmp
SELECT 'alter user &&1 identified by &&1;' nl,
       'connect &&1/&&1' nl,
       'alter user &&1 identified by values '''||u.password||''';' nl
FROM   sys.dba_users u
WHERE  u.username = UPPER('&&1')
  AND  u.username <> USER
spool off
REM DELETE the file. USE "rm" ON Unix, "del" FOR Win/Dos
! rm su.tmp
! del su.tmp
SET termout ON
SELECT 'Connected as '||USER||' on '||global_name||'.'
FROM   global_name;
SET termout ON head ON

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org