RE: SQL Developer issues
Date: Fri, 15 Feb 2013 10:19:48 -0600
Message-ID: <OF7BF8C5F9.0BF91014-ON86257B13.0059ACF7-86257B13.0059B45C_at_oshkoshcorp.com>
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-lReceived on Fri Feb 15 2013 - 17:19:48 CET