Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: privilege create session problem
"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