CODEWITHSUNDEEP
sqldatabaseprivileges
Miraj
Miraj

Reputation: 1

User granted privilege on base table so access to views already created is permitted?

User is granted access to base table by the owner so will user have access to views already created on that base table? Owner O User u2 Table (..) View v1 (partial view on table) GRANT ALL PRIVILEGES ON table to u2 WITH GRANT OPTION

Now will u2 have access to view v1?

Upvotes: 0

Views: 56

Answers (1)

Mladen Uzelac
Mladen Uzelac

Reputation: 1261

In PostgreSQL you need to grant permission on the view if you want to use it.
Grants on the table and the view are not related.

Upvotes: 1

Related Questions