Results 1 to 3 of 3

Thread: Select Any View

  1. #1
    Join Date
    Oct 2003
    Posts
    12

    Question Unanswered: Select Any View

    Please excuse my newbie inexperience, but I am hugely frustrated at my inability to get past this particular problem.

    I have created a role to which I have granted 'select any table' privileges, and want to achieve the same for views. What is the equivalent syntax? (i.e. is there a 'grant select any view to role'?)

    Ta in advance
    rusted

  2. #2
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    140
    "select any table" ALSO covers views and materialized views.

  3. #3
    Join Date
    Oct 2003
    Posts
    12
    thanks for clearing up my misunderstanding.

Posting Permissions

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