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;
精彩评论