var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Create View From Role-based Access
May I know what is wrong with the following:
1. I created a role giving select access to a user. The objects are owned by another user.
2. The user that was granted a role can do select statement but he cannot create a view out of the said table. He gets insufficient privilege.
To go around this I granted him direct access to the base table i.e grant select to user1 instead of the previous grant select to role1.
Can you please advise me what is wrong and how can I make apply the role and still allow the user to create views from the tables in the role. He already has a create view privilege.
Thank you ...
grant select grants just that. Select only.
issue grant create view on said table.