Hi, 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, but still, I have no idea how to do it.
+3
A:
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;
hamishmcn
2010-04-11 08:11:16
Often you also need a grant.
TTT
2010-04-11 08:14:09
I tried this, but still not working
Adomas
2010-04-11 08:15:13
And how to get that grant?
Adomas
2010-04-11 08:15:41
grant select on dba_users to ...
TTT
2010-04-11 08:16:31
Can't you use all_users instead of dba_users?
TTT
2010-04-11 08:17:28
To grant access (from memory) you would need to log in as SYS and type 'GRANT SELECT ON DBA_USERS TO yourotherloginname;
hamishmcn
2010-04-11 08:17:43
thanks, TTT, your the best. it helped
Adomas
2010-04-11 08:19:08
thanks hamishmcn too :) solved it
Adomas
2010-04-11 08:19:42