There exists not a list as there are no reserved words. 

So e.g., a 
 
  CREATE USER "USER" PASSWORD "PASSWORD" DBA NOT EXCLUSIVE

creates the user "USER".

(Note that, as almost always in SQL, if you want a otherwise reserved word or a weird 
string
 as identifier, you have to use quotes, *and* it becomes case-sensitive by the way.)

You may try something like 

  SELECT USERNAME FROM USERS

before, as you of course cannot create users with names that already exists. Some of 
the
existing users may have been created at installation time, so you will certainly find
SYS, SYSINFO, DOMAIN and the dba user (in your case that SYSDBA) and the dbm user 
(often
something like DBM).

Regards

Alexander Schr�der
SAP DB, SAP Labs Berlin 

> -----Original Message-----
> From: Ripin Natani [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 06, 2004 5:06 PM
> To: [EMAIL PROTECTED]
> Subject: Reserved words for username and password
> 
> 
> Hi,
>     I am looking out for a list of usernames and password 
> that are reserved and cannot be used in sapdb. I know 
> user,sysdba, domain are a few which cannot be used. Can some 
> one point out (documentation/code) where I can find this 
> reserved words' list.
>     Thanks,
>     -Ripin.
> 

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to