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: privilege create session problem

Re: privilege create session problem

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Mon, 4 Apr 2005 23:31:56 +0200
Message-ID: <4251b24d$0$30160$ba620e4c@news.skynet.be>

"Ariel Mendieta" <ariel.mendieta_at_gmail.com> wrote in message news:424f1957.0504041220.373affa4_at_posting.google.com...
> Hi
>
> I have a following problem
>
> 1. i have a 101 tables created in a regtec schema
> 2. i create public synonym for all tables in regtec's schema
> 3. i created an new user xyz, and i give it create session and select
> privilege on all public synonyms of the regtec's schema
> 4. when the xyz user log in at the database between sqlnavigator, this
> user can see all the regtec's tables and he can do an extract DDL of
> the all the tables, including views, synonyms, etc...so it can be a
> security problem,
>

Why do you think this is a security problem ? Received on Mon Apr 04 2005 - 16:31:56 CDT

Original text of this message

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