From oracle-l-bounce@freelists.org Thu Mar 11 16:52:32 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2BMqWE30000 for ; Thu, 11 Mar 2004 16:52:32 -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 i2BMqTo29987 for ; Thu, 11 Mar 2004 16:52:31 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 40D5739598A; Thu, 11 Mar 2004 16:29:26 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 16:28:08 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from irvbhxw01.prod.quest.corp (irvbhxw01.quest.com [12.106.87.68]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B8747397E8F for ; Thu, 11 Mar 2004 15:00:49 -0500 (EST) Received: from irvmbxw02.prod.quest.corp ([10.1.2.203]) by irvbhxw01.prod.quest.corp with Microsoft SMTPSVC(5.0.2195.6713); Thu, 11 Mar 2004 12:05:39 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C407A3.EB331AF2" Subject: RE: Authorete Date: Thu, 11 Mar 2004 12:03:28 -0800 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Authorete Thread-Index: AcQGNMpQtVnJhiv7Tk6z72wA8aUeWwBbudwQ From: "Jacques Kilchoer" To: Cc: "April Wells" X-OriginalArrivalTime: 11 Mar 2004 20:05:39.0070 (UTC) FILETIME=[394E99E0:01C407A4] X-archive-position: 552 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jacques.Kilchoer@quest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C407A3.EB331AF2 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Would it also work to create a logon trigger that does an "alter session = set current_schema =3D " instead of creating synonyms? -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On Behalf Of April Wells 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. =20 Granting is easy... aliasing is the interesting part.=20 Try create synonym user on whoever.user=20 Oracle tends to get testy.=20 -----Original Message-----=20 From: Richard Stevenson=20 I guess dump software from vendors that don't understand reserved words=20 wouldn't cut it?=20 =20 Seriously, wouldn't granting all privileges on the objects to another=20 user work ?=20 =20 ----- Original Message -----=20 From: April Wells < = mailto:AWells@csedge.com> =20 Has anyone worked with Authorete software against an Oracle database=20 before?=20 I am trying (silly me) to impose some security on this product, and they = have tables called... user... privilege... group... session... and I=20 need to have the tables owned by one user while another user can SUID=20 the data, but not affect the table structure (got burned on financials=20 implementation with customizations... ) and it is geeking out when the=20 user tries to log into the front end...=20 ------_=_NextPart_001_01C407A3.EB331AF2 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Authorete
Would it = also work=20 to create a logon trigger that does an "alter session set = current_schema =3D=20 " instead of creating synonyms?
-----Original Message-----
From:=20 oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On=20 Behalf Of April Wells

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

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

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

-----Original Message-----
From:=20 Richard Stevenson
I guess dump software from = vendors=20 that don't understand reserved words
wouldn't cut=20 it?
 
Seriously, wouldn't=20 granting all privileges on the objects to another
user=20 work ? 
 

 ----- = Original=20 Message -----
From: April Wells <mailto:AWells@csedge.com>  =
Has anyone worked with Authorete software against an Oracle=20 database
before?

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

------_=_NextPart_001_01C407A3.EB331AF2-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------