ANBOB™

到到当SESSION 用户名的方法很多如select user from dual; select username from user_users; SYS_CONTEXT(‘USERENV’,’CURRENT_USER’)等 等

SQL> conn test/test;
Connected.
SQL> create  table test_pro(id int,
2  name varchar2(20),
3  insertdate date);

Table created.

SQL> create or replace procedure p_user
2  is
3  begin
4  insert into test_pro(id,name,insertdate) values(userenv(‘SESSIONID’),user,sysdate);
5  end;
6  /

Procedure created.

SQL> conn system/oracle
Connected.
SQL> create public synonym p_user for test.p_user;

Synonym created.

SQL> exec p_user;

PL/SQL procedure successfully completed.

SQL> select * from test.test_pro;

ID NAME                                     INSERTDATE
———- —————————————- ————–
13000 SYSTEM                                   13-4月 -11

SQL> conn test/test
Connected.
SQL> exec p_user;

PL/SQL procedure successfully completed.

SQL> select * from test_pro;

ID NAME                                     INSERTDATE
———- —————————————- ————–
13000 SYSTEM                                   13-4月 -11
13001 TEST                                     13-4月 -11

SQL>

打赏

微信扫一扫，打赏作者吧～