1.将v$instance的select权限赋予需要使用sqlplus的用户
grant select on v$instance to public;
2.将如下的代码添加到login.sql中set termout off
select
host_name || ':' || instance_name || ':' || user || '>' prompter
from v$instance;set sqlprompt '&m_prompt'
undefine m_prompt
set termout on
grant select on v$instance to public;
2.将如下的代码添加到login.sql中set termout off
select
host_name || ':' || instance_name || ':' || user || '>' prompter
from v$instance;set sqlprompt '&m_prompt'
undefine m_prompt
set termout on
grant select_catalog_role to public;
1:
connect sys/change_on_install
grant select on v_$instance to public;
2:修改$oracle_home$\sqlplus\admin下面的login.sql
增加以下语句:
set termout off
COLUMN prompter new_value m_prompt
select host_name || ':' || instance_name || ':' || user || ' >' prompter
from sys.v_$instance;
set sqlprompt '&m_prompt'
set termout on 登录效果:
SUN:oral:TEMP >OK!
set termout off
select lower(user)||'@'||substr(global_name,1,instr(global_name,'.')-1) global_name from global_name;
set sqlprompt '&gname>'
set termout on
加在login.sql中