From oracle-l-bounce@freelists.org Tue Mar 9 18:12:02 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2A0C2a19914 for ; Tue, 9 Mar 2004 18:12:02 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2A0C1o19909 for ; Tue, 9 Mar 2004 18:12:01 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1BA5D39516E; Tue, 9 Mar 2004 19:09:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 09 Mar 2004 19:08:22 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from smtp2.corpsys.csedge.com (unknown [12.28.86.142]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2AE2739511C for ; Tue, 9 Mar 2004 19:08:15 -0500 (EST) Received: from CSMAIL.corpsys.csedge.com ([172.21.100.103]) by smtp2 with InterScan Messaging Security Suite; Tue, 09 Mar 2004 18:13:31 -0600 Received: by csmail.corpsys.csedge.com with Internet Mail Service (5.5.2653.19) id <19GPR96L>; Tue, 9 Mar 2004 18:13:30 -0600 Message-ID: <0C3690346404A94CBF4DDDD4724FC614102A8C42@csmail.corpsys.csedge.com> From: April Wells To: "'Richard Stevenson '" , "'oracle-l@freelists.org '" Subject: RE: Authorete Date: Tue, 9 Mar 2004 18:13:29 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40634.83FE3E80" X-archive-position: 251 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: AWells@csedge.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40634.83FE3E80 Content-Type: text/plain; charset="iso-8859-1" Ended up having to create case sensitive synonyms (upper case version, lower case version) on the double quoted table structures or the user couldn't log in. Granting is easy... aliasing is the interesting part. Try create synonym user on whoever.user Oracle tends to get testy. -----Original Message----- From: Richard Stevenson To: oracle-l@freelists.org Sent: 3/9/2004 5:34 PM Subject: Re: Authorete I guess dump software from vendors that don't understand reserved words wouldn't cut it? Seriously, wouldn't granting all privileges on the objects to another user work ? Regards, Richard ----- Original Message ----- From: April Wells To: 'oracle-l@freelists.org' Sent: March 09, 2004 16:38 Subject: Authorete Has anyone worked with Authorete software against an Oracle database before? I am trying (silly me) to impose some security on this product, and they have tables called... user... privilege... group... session... and I need to have the tables owned by one user while another user can SUID the data, but not affect the table structure (got burned on financials implementation with customizations... ) and it is geeking out when the user tries to log into the front end... Help? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas @>-->-->-- "Few people really enjoy the simple pleasure of flying a kite" Adam Wells age 11 "Imagination is the highest kite one can fly." Lauren Bacall The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. ------_=_NextPart_001_01C40634.83FE3E80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Authorete

 Ended up having to create case sensitive synonyms= (upper case version, lower case version) on the double quoted table= structures or the user couldn't log in. 

Granting is easy... aliasing is the interesting= part.

Try create synonym user on whoever.user
Oracle tends to get testy.

-----Original Message-----
From: Richard Stevenson
To: oracle-l@freelists.org
Sent: 3/9/2004 5:34 PM
Subject: Re: Authorete

I guess dump software from vendors that don't understand= reserved words
wouldn't cut it?
 
Seriously, wouldn't granting all privileges on the= objects to another
user work ?
 
Regards,
 
Richard

----- Original Message -----
From: April Wells <mailto:AWells@csedge.com> =
To: 'oracle-l@freelists.org' <mailto:'oracle-l@freelists.org'>= ; 
Sent: March 09, 2004 16:38
Subject: Authorete


Has anyone worked with Authorete software against an= Oracle database
before?

I am trying (silly me) to impose some security on this= product, and they
have tables called... user... privilege... group...= session... and I
need to have the tables owned by one user while another= user can SUID
the data, but not affect the table structure (got burned= on financials
implementation with customizations... ) and it is= geeking out when the
user tries to log into the front end...

Help?

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
 @>-->-->--
"Few people really enjoy the simple pleasure of= flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."=
Lauren Bacall


The information contained in this communication,= including attachments,
is strictly confidential and for the intended use of the= addressee only;
it may also contain proprietary, price sensitive, or= legally privileged
information. Notice is hereby given that any disclosure,= distribution,
dissemination, use, or copying of the information by= anyone other than
the intended recipient is strictly prohibited and may be= illegal. If you
have received this communication in error, please notify= the sender
immediately by reply e-mail, delete this communication,= and destroy all
copies.



Corporate Systems, Inc. has taken reasonable precautions= to ensure that
any attachment to this e-mail has been swept for= viruses. We
specifically disclaim all liability and will accept no= responsibility
for damage sustained as a result of software viruses and= advise you to
carry out your own virus checks before opening any= attachment.



The information=
 contained in this communication, including attachments, is strictly=
 confidential and for the intended use of the addressee only; it may also=
 contain proprietary, price sensitive, or legally privileged information.=
 Notice is hereby given that any disclosure, distribution, dissemination,=
 use, or copying of the information by anyone other than the intended=
 recipient is strictly prohibited and may be illegal. If you have received=
 this communication in error, please notify the sender immediately by reply=
 e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any=
 attachment to this e-mail has been swept for viruses. We specifically=
 disclaim all liability and will accept no responsibility for damage=
 sustained as a result of software viruses and advise you to carry out your=
 own virus checks before opening any attachment.
------_=_NextPart_001_01C40634.83FE3E80-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------