Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FGAC, other user attributes.

Re: FGAC, other user attributes.

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 2 Dec 2002 17:43:11 -0600
Message-ID: <u4r9whtwh.fsf@standardandpoors.com>


On Tue, 03 Dec 2002, gooiditweg_at_sybrandb.demon.nl wrote:
> On 2 Dec 2002 16:32:19 -0600, Galen Boyer
> <galenboyer_at_hotpop.com> wrote:
>

>> Do I create a user auxiliary
>>table with a foriegn key to sys.user$

>
>
> Definitely no foreign key to user$, as Oracle doesn't guarantee
> the names of the physical tables. You should preferably stay
> away of them like hell.

Yes. I played around with this while guessing that this was not the correct idea (hence my post), but then, how do I maintain the link between the user who has logged in and his auxiliary data?

-- 
Galen Boyer
Received on Mon Dec 02 2002 - 17:43:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US