Hi,
I want to grant create view to a user through a role.
Then grant select on the object to the role.
The user should be able to select on the object granted to the role.
So:
grant select on adminuser.tab to rl_rl;
grant create view to rl_rl;
grant rl_rl to user1;
then with user1 create view on adminuser.tab.
This of course doesn't work.
I have seen that there's a with admin option clause that can be granted, but this doens't work for a role.
My problem is that I don't want to directly grant to user. I want to pass through a role. Is there a way?
Thanks,
Tarek
I want to grant create view to a user through a role.
Then grant select on the object to the role.
The user should be able to select on the object granted to the role.
So:
grant select on adminuser.tab to rl_rl;
grant create view to rl_rl;
grant rl_rl to user1;
then with user1 create view on adminuser.tab.
This of course doesn't work.
I have seen that there's a with admin option clause that can be granted, but this doens't work for a role.
My problem is that I don't want to directly grant to user. I want to pass through a role. Is there a way?
Thanks,
Tarek