On Wed, Mar 07, 2001 at 03:40:44PM -0500, Roland Roberts wrote:
> > "bk" == Boulat Khakimov <[EMAIL PROTECTED]> writes:
>
> bk> How do I grant permissions on everything in the selected
> bk> databes?
>
> bk> GRANT doesnt take as on object database name nor does it
> bk> accept
Are you looking for "grant all to public" or "grant select to public"?
- Original Message -
From: "Roland Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, March 07,
> "bk" == Boulat Khakimov <[EMAIL PROTECTED]> writes:
bk> How do I grant permissions on everything in the selected
bk> databes?
bk> GRANT doesnt take as on object database name nor does it
bk> accept wild chars
Attached is some Perl code I wrote long ago to do this. Thi
On 3/6/01, 5:00:47 PM, Boulat Khakimov <[EMAIL PROTECTED]> wrote
regarding [SQL] Permissons on database:
> Hi,
> How do I grant permissions on everything in the selected databes?
> GRANT doesnt take as on object database name nor does it accept wild
> chars
By hand at the moment I'm afrai
Boulat Khakimov wrote:
>Hi,
>
>How do I grant permissions on everything in the selected databes?
>
>GRANT doesnt take as on object database name nor does it accept wild
>chars
However you can give it a list of tables (and other objects).
--
Oliver Elphick
