开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜