Interbase : How to create users via SQL

Jens Dein

Delphi Developer

Sat, 09 Oct 2004 21:17:29 GMT

Interbase : How to create users via SQL

I was looking in the documentation for Interbase but found no definitive
solution for how to create new users in an existing database. In oracle I
use 'create user "test" identified by "test"' and Iam lookin for something
similar in IB.

The only thing I found was a way to create a user at the same time as
creating a database but that is not what I am looking for.

Some help would be appriciated!

------
Jens Dein
System Developer
Oslo, Norway

Team

Delphi Developer

Sat, 09 Oct 2004 22:22:45 GMT

Re:Interbase : How to create users via SQL

Quote

"Jens Dein" <jens.d...@eurosoft.no.nospam> wrote:
>I was looking in the documentation for Interbase but found no definitive
>solution for how to create new users in an existing database. In oracle I
>use 'create user "test" identified by "test"' and Iam lookin for something
>similar in IB.

InterBase does not have this syntax. You can use the Serivce API (IB 6.0 and higher), the usc_add_user api call that is depreciated or directly manipulate the isc4.ggdb tables (which I highly do not reccomend).

--
Jeff Overcash (TeamB)

Other Threads

1. How I create a user via SQL

2. Interbase Password and User add/change via Delphi?

3. Help! adding users via SQL

4. creating an Interbase Table via TTable

5. Saving TMemo field data to a Blob field (Interbase Table) via SQL Update Query

6. Create Paradox AutoInc via SQL?

7. Create A Paradox Table via SQL

8. InterBase(Create User)

9. Creating a new Interbase-User within an application?

10. create user unsupported on Interbase?????