Database Security Products (MOSC)

MOSC Banner

Create view issues

edited Oct 8, 2009 7:06PM in Database Security Products (MOSC) 3 commentsAnswered
Scenario : create user user1, user2
create table user1.table1 ...
create role role1 ...
grant select on user1.table1 to role1
grant role1 to user2

Test :
connect as user2
select * from user1.table1                -- result is OK
create view view1 as select * from user1.table1     -- return error --> no privilege

Why can not create view even user2 was granted select privilege on user1.table1 from role1 ?

But if
grant select on user1.table1 to user2             -- directly grant to user2
create view view1 as select * from user1.table1     -- result is OK

Please clarify me.

Thanks,
Rawee.
 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center