开发者

How to select view in Oracle from another connection(other user)?

开发者 https://www.devze.com 2022-12-26 03:59 出处:网络
I want to select a view from my sys user, but with other connection. I need to select view DBA_USERS. Is there any way of doing so? I am new in Oracle, so maybe it is silly question, bu开发者_如何学Ct

I want to select a view from my sys user, but with other connection. I need to select view DBA_USERS. Is there any way of doing so? I am new in Oracle, so maybe it is silly question, bu开发者_如何学Ct still, I have no idea how to do it.


Have you tried select * from SYS.DBA_USERS; ? (it has been a long time since I used Oracle)
(The user you are actually connecting from may not have the privileges to read the table.)
Also you could try select * from ALL_USERS;

0

精彩评论

暂无评论...
验证码 换一张
取 消