RE: SQL Developer issues
- From: wblanchard@xxxxxxxxxxxxxxx
- To: <rajendra.pande@xxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 15 Feb 2013 10:19:48 -0600
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@xxxxxxx>
To: <wblanchard@xxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
wblanchard@xxxxxxxxxxxxxxx
Sent: Friday, February 15, 2013 11:07 AM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
