SQL Server Performance

view - permissions

Discussion in 'General Developer Questions' started by chopeen, Dec 19, 2004.

  1. chopeen Member

    Just want to make sure.

    There is a situation like on a diagram below:

    -------
    | VIEW | grant
    -------
    ^
    |
    -------
    | TABLE | deny
    -------
    A user who has been granted SELECT permission on the view and denied the SELECT permission to the table should be able to SELECT data from the view, shouldn't he?

    --

    Marek 'chopeen' Grzenkowicz

    'You're so cute when you're frustrated.' -- Interpol
  2. Chappy New Member

  3. Twan New Member

    only if the table and the view are owned by the same user

    Cheers
    Twan
  4. chopeen Member

    quote:Originally posted by Twan

    only if the table and the view are owned by the same user
    Yeah, they do.
    I forgot to mention this.

    --

    Marek 'chopeen' Grzenkowicz

    'You're so cute when you're frustrated.' -- Interpol

Share This Page