Granting permissions to entire schema

From: Mark <mrittman_at_tmf-europe.com>
Date: Wed, 24 Mar 1999 09:07:38 GMT
Message-ID: <36f8aaec.49605138_at_news.dial.pipex.com>

[Quoted] Does anyone know of a way of granting permissions (select, insert etc) on an entire schema, to a role or user?

At the moment, it appears that permissions have to be granted on a table-by-table basis. Some of our schemas have *many* tables...!

I'd be eternally grateful for any help

Mark Rittman
mrittman_at_tmf-europe.com
Toyota Motor Finance Received on Wed Mar 24 1999 - 10:07:38 CET