Share via

Access to a table through a View?

Fredrik M 206 Reputation points
2022-02-16T14:30:06.287+00:00

I have table A, that I don't have access to, but I do have access to a View B, do I get access to table A then? Or do I need access to A as well top get the view to work?

CREATE VIEW B AS
SELECT columns
FROM A

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,624 questions
0 comments
Accepted answer
  1. Tom Cooper 8,466 Reputation points
    2022-02-16T14:52:36.45+00:00

    If you have permissions to access the view, then you can access it. You don't need to have permission to access the underling table(s).

    Tom

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,731 Reputation points
    2022-02-16T17:49:11.23+00:00
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.