Hello, yes this works. Just drop the rights on the table and grand the rights on the view.
Peter Am Mittwoch, 27. April 2005 17:52 schrieb Enrico Weigelt: > Hi folks, > > we've got a larger project with several subsystems, which should > run in their own security context / users. > > 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). > Does it work to grant some user access to his own view, but > not to the tables where the view works on ? > > > thx ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
