http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FUser_Previliege%2FCurrent_User
Oracle PL/SQL/User Previliege/Current User - История изменений
2026-04-07T01:37:01Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/User_Previliege/Current_User&diff=1120&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL/User_Previliege/Current_User&diff=1121&oldid=prev
Admin: 1 версия
2010-05-26T09:55:06Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Display current user==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL><br />
SQL> show user<br />
USER is "sqle"<br />
SQL><br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Get current user==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL><br />
SQL> select user Current_User<br />
2 from dual<br />
3 /<br />
CURRENT_USER<br />
------------------------------<br />
sqle<br />
1 row selected.<br />
SQL><br />
SQL> --<br />
</source><br />
<br />
<br />
<br />
<br />
==Get current user name==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> select user from dual;<br />
USER<br />
------------------------------<br />
sqle<br />
SQL><br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Use current user name in where clause==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> select object_name, object_type<br />
2 from all_objects<br />
3 where owner = user<br />
4 /<br />
OBJECT_NAME OBJECT_TYPE<br />
------------------------------ --------------------<br />
MYTABLE_SESSION TABLE<br />
DONTCOUNTSP FUNCTION<br />
DO_COMMIT PROCEDURE<br />
DONE TABLE<br />
MY_TO_DATE FUNCTION<br />
EXITFUNC<br />
FACTORIAL<br />
EMP_CHANGE_S PROCEDURE<br />
LOG_SHUTDOWN TRIGGER<br />
ADDRESS TYPE<br />
LOG_STARTUP TRIGGER<br />
ADDRESS TYPE BODY<br />
EMP_PUBLIC_DATA VIEW<br />
EMP_NAME_CHANGE TRIGGER<br />
EMP_DEPT_PROCS PACKAGE<br />
EMP_DEPT_PROCS PACKAGE BODY<br />
DEBUG<br />
ERASE PROCEDURE<br />
GETEMPBLDGNAME FUNCTION<br />
ASSIGNEMPTOBLDG PROCEDURE<br />
DEBUG PACKAGE<br />
ADD_MON FUNCTION<br />
RAISE<br />
ASSERT PROCEDURE<br />
MAKE_MYTABLE<br />
WRITE_NAME<br />
HELLO<br />
EMP_CHG TYPE<br />
EMP_CHANGES TABLE<br />
SYS_C005784 INDEX<br />
SYS_LOB0000016238C00034$$ LOB<br />
AQ$_EMP_CHANGES_S TABLE<br />
SYS_C005787 INDEX<br />
AQ$_EMP_CHANGES_V EVALUATION CONTEXT<br />
AQ$_EMP_CHANGES_T TABLE<br />
AQ$EMP_CHANGES_S VIEW<br />
AQ$_EMP_CHANGES_N SEQUENCE<br />
SYS_IOT_TOP_16247 INDEX<br />
AQ$_EMP_CHANGES_H TABLE<br />
EMPLOYEES_LIST TYPE<br />
EMPLOYEE_TYPE<br />
VIEW_T VIEW<br />
STATE_PACKAGE PACKAGE<br />
SHAPE TYPE<br />
DEPT_EMP_VIEW VIEW<br />
IO_BIFER_DEPT_EMP_VIEW TRIGGER<br />
DEPARTMENT_10 VIEW<br />
COMPILE_SCHEMA_TMP_PK INDEX<br />
GET_NEXT_OBJECT_TO_COMPILE PROCEDURE<br />
COMPILE_SCHEMA<br />
COMPILE_SCHEMA_TMP TABLE<br />
PRINT_TABLE PROCEDURE<br />
SHOW_SPACE<br />
DEBUG_TIMER<br />
VC2TAB TYPE<br />
P PROCEDURE<br />
PEOPLE PACKAGE<br />
PEOPLE PACKAGE BODY<br />
TEMP_EMP TABLE<br />
P_ADD_PROD PROCEDURE<br />
P_ADD_EMPS<br />
P_ADD_ORDERS<br />
MEASURE_USAGE<br />
SYS_IOT_TOP_15816 INDEX<br />
UPPER_ENAME TABLE<br />
SHOW_IOT_SPACE PROCEDURE<br />
SYS_IOT_TOP_16249 INDEX<br />
SYS_IOT_OVER_16251 TABLE<br />
AQ$_EMP_CHANGES_G<br />
SYS_IOT_TOP_16251 INDEX<br />
AQ$_EMP_CHANGES_I TABLE<br />
SYS_IOT_TOP_16254 INDEX<br />
AQ$_EMP_CHANGES_E QUEUE<br />
AQ$_EMP_CHANGES_F VIEW<br />
AQ$EMP_CHANGES<br />
EMP_DEPT_CHANGES_R RULE SET<br />
EMP_DEPT_CHANGES_N<br />
AQ$EMP_CHANGES_R VIEW<br />
EMP_DEPT_CHANGES QUEUE<br />
DEPT_AND_EMP TABLE<br />
FILE_DUMP PROCEDURE<br />
EMP_REG TABLE<br />
EMP_TYPE TYPE<br />
EMP_TAB_TYPE<br />
EMPS_NT TABLE<br />
SYS_C005826 INDEX<br />
SYS_C005827<br />
SUPER_TYPE TYPE<br />
SESS_EVENT TABLE<br />
NEW_PERSON TYPE<br />
PERSON<br />
NEW_PERSON TYPE BODY<br />
LOGON_TRIGGER TRIGGER<br />
VIRTUAL_TABLE_TYPE TYPE<br />
ROWTYPE<br />
ELEMENTTYPE<br />
RESULTTYPE<br />
COMPANY_LISTING PROCEDURE<br />
PIVOT FUNCTION<br />
VIRTUAL_TABLE<br />
REMOVE_CONSTANTS<br />
SQL_AREA_TMP TABLE<br />
<br />
102 rows selected.<br />
SQL><br />
SQL><br />
SQL> --<br />
</source></div>
Admin