一般显示为：
SQL> show user
USER 为 "SYS"
SQL>
在 $ORACLE_HOME/sqlplus/admin目录下 编辑glogin.sql文件
set termout off
define gname=idle
column global_name new_value gname
select lower(user)||’@’
||substr(global_name,1,decode(dot,0,length(global_name),dot-1))
global_name from (select global_name, instr(global_name,’.') dot from
global_name);
set sqlprompt ‘&gname>’
set termout on
[root@ls ~]# su - oracle
[oracle@ls ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 11 11:05:46 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
sys@LS1>show user
USER is "SYS"
sys@LS1>
sys@LS1>conn scott
Enter password:
Connected.
scott@LS1>show user
USER is "SCOTT"
scott@LS1>