Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: current users enquiry
gd6502_at_eudoramail.com wrote:
> DA Morgan ha scritto:
>
>> gd6502_at_eudoramail.com wrote: >>> I forgot... >>> >>> DA Morgan ha scritto: >>>> SELECT grantee, table_name, privilege >>>> FROM user_tab_privs_made; >>>> >>>> -- and for the other half of the equation: >>>> SELECT grantor, table_name, privilege >>>> FROM user_tab_privs_recd; >>>> >>> The query both return an empty recordset. >>> >>> Peppe >> Then no object privileges have been granted or received >> by the schema owner.
Sure you can. You can ask the DBA team.
You sure are acting like you've something to hide.
> It seems so strange to me; every other db I know can do that.
Every other db is not Oracle. <g>
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sun Dec 17 2006 - 15:41:11 CST