RE: SQL Developer issues

From: <wblanchard_at_oshkoshcorp.com>
Date: Fri, 15 Feb 2013 10:31:31 -0600
Message-ID: <OF8DB7548F.03C1F66A-ON86257B13.005AB146-86257B13.005AC711_at_oshkoshcorp.com>

They're able to see the trigger on the left side in the navigation pane. On the right side they just see the create or replace.

WGB From: Brian Pardy <brianpa_at_burton.com> To: "wblanchard_at_oshkoshcorp.com" <wblanchard_at_oshkoshcorp.com> Date: 02/15/2013 10:28 AM
Subject: RE: SQL Developer issues

Is there any chance that the user has a filter set up in SQL Developer in their view of the test database that's excluding these triggers?

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [
mailto:oracle-l-bounce_at_freelists.org] On
> Behalf Of wblanchard_at_oshkoshcorp.com
> Sent: Friday, February 15, 2013 11:20 AM
> To: rajendra.pande_at_ubs.com; oracle-l_at_freelists.org
> Subject: RE: SQL Developer issues
>
> I looked at the dependent objects and the user has the correct
privileges on the
> underlying objects. What's weird is that she can see the code in prod
but not in
> test.
>
>
> WGB
>
>
>
>
>
> From: <rajendra.pande_at_ubs.com>
> To: <wblanchard_at_oshkoshcorp.com>
> Date: 02/15/2013 10:11 AM
> Subject: RE: SQL Developer issues
>
>
>
> I have seen similar access issues where the privileges are granted on
the
> underlying objects directly vs via a role
>
>
> Raj Pande
> GSDM, DB Services
> - 201 725 3026
> -
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> wblanchard_at_oshkoshcorp.com
> Sent: Friday, February 15, 2013 11:07 AM
> To: oracle-l_at_freelists.org
> Subject: SQL Developer issues
>
> So I've got triggers in the production and test database. A user
reported that
> she can't see the trigger code in test but can in production. There are
no grants
> on the trigger and she only has select access to the tables in prod.
> To test, I created a user and granted the same privs and can see the
code in both
> prod and test.
>
> Any thoughts? Anyone see this before?
>
>
>
> Thank you,
>
> WGB
>
> Although this e-mail and any attachments are believed to be free of any
virus or
> other defect which might affect any computer system, it is the
responsibility of
> the recipient to check that it is virus-free and the sender accepts no
> responsibility or liability for any loss, injury, damage, cost or
expense arising in
> any way from receipt or use thereof by the recipient.
>
> The information contained in this electronic mail message is
confidential
> information and intended only for the use of the individual or entity
named
> above, and may be privileged. If the reader of this message is not the
intended
> recipient, you are hereby notified that any dissemination, distribution
or copying
> of this communication is strictly prohibited. If you have received this
> transmission in error, please contact the sender immediately, delete
this
> material from your computer and destroy all related paper media. Please
note
> that the documents transmitted are not intended to be binding until a
hard copy
> has been manually signed by all parties.
> Thank you.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> Please visit our website at
> http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
> for important disclosures and information about our e-mail policies. For
your
> protection, please do not transmit orders or instructions by e-mail or
include
> account numbers, Social Security numbers, credit card numbers,
passwords, or
> other personal information.
>
>
>
> Although this e-mail and any attachments are believed to be free of any
virus or
> other defect which might affect any computer system, it is the
responsibility of
> the recipient to check that it is virus-free and the sender accepts no
> responsibility or liability for any loss, injury, damage, cost or
expense arising in
> any way from receipt or use thereof by the recipient.
>
> The information contained in this electronic mail message is
confidential
> information and intended only for the use of the individual or entity
named
> above, and may be privileged. If the reader of this message is not the
intended
> recipient, you are hereby notified that any dissemination, distribution
or copying
> of this communication is strictly prohibited. If you have received this
> transmission in error, please contact the sender immediately, delete
this
> material from your computer and destroy all related paper media. Please
note
> that the documents transmitted are not intended to be binding until a
hard copy
> has been manually signed by all parties.
> Thank you.
>
> --
> http://www.freelists.org/webpage/oracle-l
>

Although this e-mail and any attachments are believed to be free of any virus or other defect which might affect any computer system, it is the responsibility of the recipient to check that it is virus-free and the sender accepts no responsibility or liability for any loss, injury, damage, cost or expense arising in any way from receipt or use thereof by the recipient.

The information contained in this electronic mail message is confidential information and intended only for the use of the individual or entity named above, and may be privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this transmission in error, please contact the sender immediately, delete this material from your computer and destroy all related paper media. Please note that the documents transmitted are not intended to be binding until a hard copy has been manually signed by all parties. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 15 2013 - 17:31:31 CET