Role question???

From: Tung Nguyen <tung_at_system9.unisys.com>
Date: Thu, 2 Mar 1995 14:54:35 GMT
Message-ID: <1995Mar2.145435.15465_at_system9.unisys.com>

Hi all,

Is there a way to define a role so that it has select/read privileges on all of the tables in a schema?

What I have been doing is each time a new table is created in the schema I have to manually grant select privilege on that table to the role.

Thanks in advance.

Tung Nguyen (tung_at_system9.unisys.com)

---

Disclaimer: The contents in this post are mine only. Received on Thu Mar 02 1995 - 15:54:35 CET