var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Views and Roles and Security
I have a problem (probably just a misunderstanding) which is driving me insane ... please help put me out of my misery.
I have created some roles and assigned privileges as follows:
CREATE ROLE RL_DDL NOT IDENTIFIED;
GRANT CREATE ANY VIEW,DROP ANY VIEW TO RL_DDL;
CREATE ROLE RL_ADM1 NOT IDENTIFIED;
GRANT RL_DDL TO RL_ADM1 WITH ADMIN OPTION;
I then have created a user USR1 who has been added to the RL_ADM1 role.
USR1 has direct select permissions on SCHEMA2.TABLE2
When I connect as USR1 and attempt the following, I get an 'Insufficient Privileges' error.
CREATE OR REPLACE VIEW SCHEMA1.VIEW1 AS
SELECT * FROM SCHEMA2.TABLE2
You need to grant select on SCHEMA2.TABLE2 with grant option
Thanks JHarvey ... that did the trick.