[PHP-DB] parse error in create statement.

2005-06-14 Thread babu 
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

Re: [PHP-DB] parse error in create statement.

2005-06-14 Thread Chris Ramsay 
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

Re: [PHP-DB] parse error in create statement.

2005-06-14 Thread Chris Ramsay 
Also, correct me if I'm wrong, but this needs to be split into two
seperate query strings and executed seperately...

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] parse error in create statement.

2005-06-14 Thread Darryl Steyn 
$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.;

for the .'s

Re: [PHP-DB] parse error in create statement.

2005-06-14 Thread Bastien Koert 
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