| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Finding out if user has connect through granted
Hi,
I've searched the manual and Metalink and not found an answer on this.
We're on 81745 under Windows 2000.
If users fred and bill exist and I've done:
alter user fred grant connect through bill;
how can I query a view to show this statement? eg - If I want to use a script to recreate the SQL to create the user?
It doesn't seem to be in dba_sys_privs or dba_role_privs which makes = some sense because it would need to store 2 items, you've got the priv = and who you've got it for - so there's probably a child table somewhere.
I've got showpriv.sql from Jacques Kilchoer but the version I have is = from Sep 1998 and doesn't include this, nor does the find_all_privs.sql = from Pete Finnigan (version 1.5) - but maybe I'm missing something.
For info, it seems that in 8i, these grants are lost on an import - bug = 2489566
Thanks,
Bruce Reardon
NOTICE: This e-mail and any attachments are private and confidential and = may contain legally privileged information. If you are not an = authorised recipient, the copying or distribution of this e-mail and any = attachments is prohibited and you must not read, print or act in = reliance on this e-mail or attachments. This notice should not be = removed.
 |
 |