Helpful Information
 
 
Category: Firebird SQL Development
Create user with ODBC

Can I create/add a user with ODBC ?

Do you have a firebird odbc installed? If so, yes you can create a user with ODBC.

Originally posted by victorpendleton
Do you have a firebird odbc installed? If so, yes you can create a user with ODBC.
Yes, I have ODBC installed (from IBPhoenix.com), but I don't know how do it. I can't find "CREATE USER ..." sql command in the IB6 documentation

From the gse command line:
add name -pw password
...
You can find this information on page 100 of the operations manual.

Originally posted by victorpendleton
From the gse command line:
add name -pw password
...
You can find this information on page 100 of the operations manual.
NO. I whant to create user directly from my application, not from a command line tool. In MS Sql Server I use "sp_grantlogin", in PostgreSQL I use "CREATE USER ...". May be I have to insert direct into security.fbd, but I don't know how to manage the password !!!










privacy (GDPR)