Re: Role question???
From: Contractor - Yuktton <jychan_at_corp.hp.com>
Date: 1995/05/23
Message-ID: <3pthof$ohk_at_hpcc48.corp.hp.com>#1/1
Date: 1995/05/23
Message-ID: <3pthof$ohk_at_hpcc48.corp.hp.com>#1/1
Tung Nguyen (tung_at_system9.unisys.com) wrote:
: 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)
: ==========================================================================
there a privilege you can grant:
grant select any table to user;
: Disclaimer: The contents in this post are mine only.
jc Received on Tue May 23 1995 - 00:00:00 CEST