Re: Roles

"g3000" <carlton_gregory_at_yahoo.com> a écrit dans le message de news:1109109949.491905.192730_at_c13g2000cwb.googlegroups.com...
| Thanks for the reply.
|
| Then in my case. When I create the schema I create the roles and give
| the roles privileges as SYS.
|
| So when I drop the schema the roles are used for, the privileges do not
| go away.
|
| Because I am not regranting any privileges except the privileges
| granted by SYS to the schema I dropped.
|
| I also regrant the roles to the schema owner with admin option.
|
| I solved the issue nonetheless. Before the schema owner was being
| imported and all roles were granted to it WITHOUT admin option and they
| were NOT the default roles.
|
| I changed this to granting all roles to the schema owner with admin
| option and making them all default roles.
|
| I assume when users use the schema owners packages to log in ( with
| definer rights ) the definer has to have admin privileges to set
| another users role for there session ( dbms_session.set_role was being
| called ).
|
| But it was killing be because I assumed since the definer had the roles
| granted to it, it should have worked. I even explicitly granted the
| required roles to the user outside of the package and it still didnt
| work.
|
| Anyway Im going to do more testing but I think Ive solved it.
|

I'm not sure i understand your whole case but one hint: roles are not enable in procedure/package.

If this not your issue, please post a test case.

Regards
Michel Cadot Received on Tue Feb 22 2005 - 23:06:52 CST