s******y
发帖数: 68 | 1 在Oracle下,
怎么才能知道当前的schema是什么 ?
对于某个table, 如何查看在不同 schema中的accessibility 是什么?
thanks
| I******e
发帖数: 101 | 2 Not sure your question: can you give an example? | c*****d
发帖数: 6045 | 3 show user
select * from user_tab_privs | B*****g
发帖数: 34098 | 4 kick, lz needs schema not user.
select sys_context('USERENV','SESSION_SCHEMA') from dual
【在 c*****d 的大作中提到】
: show user
: select * from user_tab_privs
| c*****d
发帖数: 6045 | 5 en, beijing is right
"show user" displays the username to access SQL*Plus, which is the same as
schema in most cases. In case of switching schema, they are not the same
sys_context can get the current schema. It is much convenience and accurate
than "show user"
【在 B*****g 的大作中提到】
: kick, lz needs schema not user.
: select sys_context('USERENV','SESSION_SCHEMA') from dual
|
|
