Re: Role question???
From: Thomas Conte <Thomas.Conte_at_DaytonOH.ATTGIS.COM>
Date: 1995/05/25
Message-ID: <D957G3.LwM_at_ranger.daytonoh.attgis.com>#1/1
>: Disclaimer: The contents in this post are mine only.
>
>there a privilege you can grant:
>
>grant select any table to user;
>
>jc
>
Received on Thu May 25 1995 - 00:00:00 CEST
Date: 1995/05/25
Message-ID: <D957G3.LwM_at_ranger.daytonoh.attgis.com>#1/1
I think the important part of Tungs' question is can it be accomplished for "a schema". Granting select any table will allow the user to do just that, select any table, any schema. If security / data sensitivity isn't a problem then go for it.
Tom
>==========Contractor - Yuktton "Jonny" Cha, 5/23/95==========
>
>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)
>:
>: Disclaimer: The contents in this post are mine only.
>
>there a privilege you can grant:
>
>grant select any table to user;
>
>jc
>
Received on Thu May 25 1995 - 00:00:00 CEST