Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    12

    Angry 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

    Any ideas...?

  2. #2
    Join Date
    Oct 2003
    Location
    UK
    Posts
    7
    You need to grant select on SCHEMA2.TABLE2 with grant option

  3. #3
    Join Date
    Oct 2003
    Posts
    12
    Thanks JHarvey ... that did the trick.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •