Re: Rights needed to connect oracle7 DB

"Howard J. Rogers" <hjr_at_dizwell.com> a wrote
> If I summarise your script, it says:
>
> create role X;
> create user Y;
> grant select on a table to X;
> grant role X to user Y;
>
> So, user Y should be able to select from the table? Not unless user Y logs
> on and then issues the command
> SET ROLE X;
>
> The alternative is to say:
>
> alter user Y default role all;
>
> (or ...default role X if you want to be very specific).
>
> A default role is one which is switched on merely by virtue of the user
> logging on to the database, so no explicit 'set role' command is needed to
> activate it.
>
> If I've misunderstood the problem, my apologies.
>
> Regards
> HJR
>

Do not apologies... that was a wonderful answer... I didn't think I had to activate the role on the user after having granted him the role. After having regularized the owner of the tables (which was sys) by creating a dba for the db, I applied the role on the owner.tables and altered the user with a default (and specific) role. Thanks a lot. - That's available for the others who helped me too -

Best regards

Romain A Received on Sat May 29 2004 - 14:39:13 CDT