Re: Can you grant select on a whole schema?

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Mon, 14 Jan 2002 15:57:50 +0000
Message-ID: <3C42FFFE.CA95950C_at_exesolutions.com>

No.

Though you can easily write a stored procedure using native dynamic SQL that will grant it on all tables in user_tables.

Daniel Morgan

steve deno wrote:

> Help is appreciated!
Received on Mon Jan 14 2002 - 16:57:50 CET

This message: [ Message body ]
Next message: jdavis68_at_epix.net: "Re: Any oracle DMBS for palm?"
Previous message: hank: "Re: Oracle 8i (8.1.7) problem with a lot of simultaneous connections -> ORA-12541 No listener available"
In reply to: steve deno: "Can you grant select on a whole schema?"
Next in thread: Slarti: "Re: Can you grant select on a whole schema?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message