Re: v6 to v7 data dict view question
From: Dave Mausner <dmausner_at_brauntech.com>
Date: 15 Nov 1994 00:20:15 GMT
Message-ID: <3a8urv$6ep_at_News1.mcs.com>
Date: 15 Nov 1994 00:20:15 GMT
Message-ID: <3a8urv$6ep_at_News1.mcs.com>
In article <3a8cqd$d95_at_info-server.bbn.com>, jkelly_at_bbn.com (Jim Kelly) says:
>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?
you must join the view USER_ROLE_PRIVS because connect, resource, and
dba are not flags in the user row, but role names assigned to each
user.
--
Dave Mausner, Sr. Consultant, Braun Technology Group, Chicago.
Received on Tue Nov 15 1994 - 01:20:15 CET