关于schema# Database - 数据库
s*y
1 楼
在Oracle下,
怎么才能知道当前的schema是什么 ?
对于某个table, 如何查看在不同 schema中的accessibility 是什么?
thanks
怎么才能知道当前的schema是什么 ?
对于某个table, 如何查看在不同 schema中的accessibility 是什么?
thanks
I*e
2 楼
Not sure your question: can you give an example?
c*d
3 楼
show user
select * from user_tab_privs
select * from user_tab_privs
B*g
4 楼
kick, lz needs schema not user.
select sys_context('USERENV','SESSION_SCHEMA') from dual
【在 c*****d 的大作中提到】
: show user
: select * from user_tab_privs
select sys_context('USERENV','SESSION_SCHEMA') from dual
【在 c*****d 的大作中提到】
: show user
: select * from user_tab_privs
c*d
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
"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
相关阅读
what is wrong with the statement?数据库方向的UNIV。？disk access and DB2access 2000 的问题，虚心请教！why I cann't get some char variable?Re: [转载] 我的asp脚本为什么总是出现"数据库对象不能更新"的错误 ？小声问: what's content of database design and implementation ?How to import data from excel files to mysql DB?help on oemapp为啥SQL server 在win2000 pro 下也能用呢?MySQL on MacLooking for DB SWquestion: how to drop a tablespacethe most stupid questionoracle的SQL跟foxpro的SQL相差很大么？安装mysql遇见的问题。oracle nologging mode --- Help, pleasejdbc to db2 on linux问题MySql Question[转载] 请问asp需要的IIS的缺省密码是什么呀