Re: Questions on ODBC and Oracle Product user profile

Greg Burns <gburns_at_telerama.lm.com> wrote

> My question is this: Do SQL*Net and the ODBC drivers abide by Oracle's
> Product User profile settings? Currently, the product user profile util
> prevents users from updating, deleting, and inserting. We want to keep it
> that way.

I could be completely wrong, but in my experience, Oracle will abide by the 'user profile' (or do you mean 'roles' in this case) regardless of how you have logged in (ODBC, SQLNET or local).

Could any readers correct me if I'm wrong. There is an exception to the rule I'm sure...

-- 
Guy van der Werf - guy_at_londonoffice.com or guy_at_sydneyoffice.com
Director, consultant, designer, developer and tea-boy at
Libran Systems Ltd, UK