Hi,
> 1-I want to use sqlcli but can't get in.
> I am using 7.5.0.5 on SuSE Linux prof 8.2
>
> dell3:/opt/sdb # programs/bin/sqlcli -d test6 -u jeroen,geheim
>
> Welcome to the SAP DB interactive terminal.
>
> Type: \h for help with commands
> \q to quit
> test6 => \s
> * -4008: Unknown user name/password combination SQLSTATE: 08004
> test6 => \q
> dell3:/opt/sdb #
>
> This user has al the rights according to webdbm so what am I
> doing wrong?
Maybe you use the "DBMUSER" instead of the "SQLUSER".
You have to distinguish between administrative users for the DBM
("DBMUSER") and the ("real") database users for SQL ("SQLUSER").
The DBMUSERs are saved outside from the database (for OFFLINE use).
You can use this users only to get a DBMServer logon and execute
DBMServer commands. The task of this user is to administrate the
database (start, stop, backup etc.). The SQL interface don't know
them. You can only create and maintain this users via DBMServer
commands."
The SQLUSERs are the users for your database operations via a SQL
interface. The task of this users is to save and find data in the
database. The users are saved inside the database. You can create
and maintain this users via DBM commands ("user_*") with
"SQLUSER=YES". The better way is to create and maintain this users
via a SQL interface with "create user ..." oder "alter user ..."
statements. In this case the DBM don't know this users, but is not
necessary for the DBM to know this users.
Regards,
Marco Paskamp
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
