Re: Setting ODBC user priveleges

Thanks. But I didn't say GRANT CONNECT. Not that it should affect the outcome of this experiment but I am against every granting CONNECT to any user. I suggested you grant CREATE SESSION.

Daniel A. Morgan

Darryl wrote:

> "Daniel A. Morgan" wrote....>
> >
> > When you connect to Oracle through ODBC you see the objects visible to the
 user
> > that connected. What user do you connect with and what privileges does
 that user
> > have?
>
> I created a new user, then issued this command: GRANT CONNECT TO NEWUSER;
> When I log in as this user through ODBC, I can see all the PUBLIC and SYS
> objects.
>
> > Try creating a user with no privilege other than CREATE SESSION and see if
 that
> > limits your view of objects in other schemas. Then GRANT SELECT to that
 user on
> > a single table in another schema and see if only that table becomes
> visible.
>
> I'll try it Monday.
>
> > If not ... I'd like to hear what your experience is.
>
> I'll let you know. Keep in mind I'm not an Oracle DBA - just a
> developer/analyst having to perform Junior DBA duties on this project.
>
> Thanks,
> Darryl
Received on Mon Mar 12 2001 - 00:03:08 CST