Re: Substitutions

From: Gokoel, S. <Sjam.Gokoel_at_AkzoNobel.com>
Date: Fri, 31 Jul 1998 14:04:10 +0200
Message-ID: <01bdbc7a$bd6e5b00$3248020a@ahm02458.Arnhem-nl.akzonobel.nl>

Gocha,

You should put 2 '&' signs for Username. So your statement should be: CREATE USER &&Username IDENTIFIED BY &PWord GRANT CREATE ANY TABLE TO &&Username

I hope this helps.
Good luck.

Sjam Gokoel (email: Sjam.Gokoel_at_Akzonobel.com)

Gocha Mchedlishvili <gocham_at_mci2000.com> wrote in article <9oOv1.3241$__4.777497_at_news.mci2000.com>...
> I want to make SP, which propts for user name and password and then
creates
> the user
> I wrote the code
>
> CREATE USER &UserName IDENTIFIED BY &PWord
> GRANT CREATE ANY TABLE TO &UserName
>
> When I run this script, I'm prompted twice for username.
>
> How to make it to prompt it only once?
>
> Thanks
>
> Gocha
>
>
>
>
>
Received on Fri Jul 31 1998 - 07:04:10 CDT