Re: Help! I'm accused of breaching security!

dseuser_at_my-deja.com wrote:
>
> At work we use a popular Oracle database application for college
> administration. The DBA granted select privileges so end-users could
> connect with Access to the tables in their module. Today I logged in to
> SQLPlus, which is loaded on every machine with the Access ODBC driver. I
> wanted to learn about SQL.
>
> DBA has called my boss to say I've breached security. I say, can't be,
> since the DBA set up security of select only and only to my tables.
>
> Can the DBA be right? If she is, doesn't that implicate that the
> security she set up is pretty bad?
>
> Thanks,
> Dwight
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

I hate to bad mouth another DBA, but if:

1. you logged in using your own login id
2. you are using only software the college loaded on your PC

you didn't do anything wrong and your DBA is the one with the problem. If the college does not want users to access the database using SQL*Plus it shouldn't be installed on the clients.

If the college doesn't want people to use SQL*Plus it shouldn't be installed on their PCs. Whoever installed the Oracle software on the clients should not have installed SQL*Plus. The only Oracle software that should have been installed is SQL*Net (Net80 if using 8.x).

hth

--
Jerry Gitomer
Once I learned how to spell DBA, I became one. Received on Tue Feb 01 2000 - 23:54:17 CST