Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    10

    Unanswered: Rights for creating and replacing views in oracle?

    Hi,
    Which Rights are needed to create and replace view in oracle, that user already have rights to create view, but it get the insufficient privileges while creating a view.


    Best Regards,
    Mushq

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    How's that again?
    that user already have rights to create view, but it get the insufficient privileges while creating a view.
    I believe you are looking for ALTER ANY TABLE privilege.

    If not, check GRANT statement in Oracle documentation and see what this document says about the issue.

  3. #3
    Join Date
    Nov 2006
    Location
    Indianapolis
    Posts
    90
    Is the owner of the view also the owner of the table? If not then the view-owner will need explicit privileges granted on the 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
  •