Home -> Usenet -> comp.databases.oracle -> v6 to v7 data dict view question

v6 to v7 data dict view question

From: Jim Kelly <jkelly_at_bbn.com>
Date: 14 Nov 1994 19:12:13 GMT
Message-ID: <3a8cqd$d95_at_info-server.bbn.com> 






I've been updating our database and application from v6 to v7 and have one
data dictionary view question:



In the v6 version I could do "select username, connect_priv from dba_users"
to get a list of what users currently have connection privilege.  In v7
connect_priv, resource_priv, and dba_priv are no longer part of the
dba_users view.  Anyone know where I can get at this info now?



Thanks,


-Jim
Received on Mon Nov 14 1994 - 20:12:13 CET












Original text of this message