Enrico Weigelt <weigelt@xxxxxxxx> writes: > Most of the database access works over views and functions. > For functions its possible to run them with separate privileges > than the calling user. But is this also possible with views ? > I've noticed that for views also GRANT is necessary (AFAIK a > view is nothing else than a table with appropriate RULEs). You have noticed incorrectly. A view's references to other tables are privilege-checked with respect to the owner of the view. regards, tom lane
