Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create view to user through a role

Status
Not open for further replies.

7280

MIS
Apr 29, 2003
331
IT
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top