Missing a . in the line before the last quote GRANT CREATE TRIGGER TO
".$adduser"
"$sqlstmt= "CREATE USER ".$adduser." PROFILE DEFAULT
IDENTIFIED BY ".$addpass." DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED
ON USERS
ACCOUNT UNLOCK;
GRANT CREATE TABLE TO ".$adduser."
GRANT CREATE TRIGGER TO ".$adduser."
GRANT CONNECT TO ".$adduser;".
bastien
From: Chris Ramsay <[EMAIL PROTECTED]>
Reply-To: Chris Ramsay <[EMAIL PROTECTED]>
To: babu <[EMAIL PROTECTED]>
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] parse error in create statement.
Date: Tue, 14 Jun 2005 10:56:24 +0100
Check your placement of all the '.' for a start.
raz
On 6/14/05, babu <[EMAIL PROTECTED]> wrote:
> HI,
>
> Whats the error in this code.
>
> "$sqlstmt= "CREATE USER ".$adduser." PROFILE DEFAULT
> IDENTIFIED BY ".$addpass." DEFAULT TABLESPACE USERS
> TEMPORARY TABLESPACE TEMP
> QUOTA UNLIMITED
> ON USERS
> ACCOUNT UNLOCK;
> GRANT CREATE TABLE TO ".$adduser."
> GRANT CREATE TRIGGER TO ".$adduser"
> GRANT CONNECT TO ".$adduser;".
>
>
> any suggestions.
>
>
>
> ---------------------------------
> Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with
voicemail
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
