Re: Stupid Questions about users
From: Jay Collins <jcollin_at_exis.net>
Date: Thu, 21 Feb 2002 12:27:58 -0500
Message-ID: <Pine.LNX.4.33.0202211226500.16918-100000_at_tarpon.exis.net>
Date: Thu, 21 Feb 2002 12:27:58 -0500
Message-ID: <Pine.LNX.4.33.0202211226500.16918-100000_at_tarpon.exis.net>
On Thu, 21 Feb 2002, Jim Kennedy wrote:
>It is standard ansi sql
>grant select on object_name to bob;
>...
Hmm. I must not be doing something right. I'm trying to give a user select on all objects in the table, but it says the table or view don't exist.
Ie.
GRANT SELECT ON "*" to fred;
? Received on Thu Feb 21 2002 - 18:27:58 CET