Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Kuwait
    Posts
    27

    Unanswered: Create View From Role-based Access

    Hello Gurus,

    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 ...

  2. #2
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    grant select grants just that. Select only.
    issue grant create view on said table.

Posting Permissions

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