schema和user的区别

Yong Huang

I thought of one interesting question. Oracle has this SQL:

alter session set current_schema = ...

which allows you to omit the owner of the object in subsequent SQLs. If you were to design or re-design this SQL, would you call it current_schema or current_user, or even current_owner or current_account? Practically, it makes no difference. But if we insist on the *meaning* of the word, this is a good time to make the terminology "right".

zergduan

Yong Huang 发表于 2015-6-20 02:36
I thought of one interesting question. Oracle has this SQL:

alter session set current_schema = .. ...

   

sykace

那sys作为sysoper登录的时候应该算是一个用户吧，但是他的schema呢？

zergduan

sysoper是身份，或者说权限。既不是user也不是schema...