Re: MSACCESS hangs
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 23 Jul 2008 13:05:18 -0700
Message-ID: <1216843514.339474@bubbleator.drizzle.com>
>> www.psoug.org
>
> Again note, I'm not seeing user$ via Access, this is what I queried
> out of the database of what the session was running. It's either a
> piece of sql that Oracle runs behind the scenes, or, what Access
> runs. In other words, the user is trying to get MS Access to get them
> a list of objects and it's not coming up.
>
> I don't disagree with you in regards to patching, it needs to get done
> but has not. I also don't disagree with the use of Access as a front
> end but I do not have control over that, I'm not the application
> developer.
>
> Pete's
Date: Wed, 23 Jul 2008 13:05:18 -0700
Message-ID: <1216843514.339474@bubbleator.drizzle.com>
Pete's wrote:
>> There is no way you should be logging in with MS Access and seeing >> user$ under normal circumstances. If you can see it then you should >> explain what system privs/roles were granted that allow it. >> >> What you are describing is possibly a gross security breach. >> -- >> Daniel A. Morgan >> Oracle Ace Director & Instructor >> University of Washington >> damor..._at_x.washington.edu (replace x with u to respond) >> Puget Sound Oracle Users Group
>> www.psoug.org
>
> Again note, I'm not seeing user$ via Access, this is what I queried
> out of the database of what the session was running. It's either a
> piece of sql that Oracle runs behind the scenes, or, what Access
> runs. In other words, the user is trying to get MS Access to get them
> a list of objects and it's not coming up.
>
> I don't disagree with you in regards to patching, it needs to get done
> but has not. I also don't disagree with the use of Access as a front
> end but I do not have control over that, I'm not the application
> developer.
>
> Pete's
Wrong!
You can't query what you can't see. Your statement clearly indicates that you can see USER$ and other catalog tables owned by SYS.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Jul 23 2008 - 15:05:18 CDT