#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12

    Question Create user with ODBC


    Can I create/add a user with ODBC ?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    Do you have a firebird odbc installed? If so, yes you can create a user with ODBC.
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12
    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
    Last edited by goreXP; July 9th, 2003 at 01:49 AM.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    From the gse command line:
    add name -pw password
    ...
    You can find this information on page 100 of the operations manual.
  8. #5
  9. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12
    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 !!!

IMN logo majestic logo threadwatch logo seochat tools logo