Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    The Netherlands

    Unanswered: object privileges

    I made the following view:

    CREATE OR REPLACE VIEW ish.applview_PrimaryKeyElements AS
    SELECT table_name, as column_name
    FROM sys.col$ a, sys.ccol$ b, sys.con$ c, sys.obj$ d, sys.cdef$ e, sys.user$ f
    WHERE a.obj# = b.obj#
    AND a.intcol# = b.intcol#
    AND b.con# = c.con#
    AND a.obj# = d.obj#
    AND e.con# = b.con#
    AND c.owner# = f.user#
    AND = 'ISH'
    AND e.type# = 2
    ORDER BY, b.pos#

    Now I want to give, to a normal user who has almost no privileges, the select-privilege on this view. But therefor the user has to be given also the select-rights on all the sys-tables used in this view. Is there no other easy way to let the user see the view!

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1

    Re: object privileges

    The user does not have to have select rights on the underlying tables of the view - that is one of the advantages of views.

    However, the creator of the view (i.e. ISH) must have DIRECT select privileges on the underlying tables of the view, not via a role. I suspect this is your problem.

Posting Permissions

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