Subject | RE: [IBO] Using a different user |
---|---|
Author | Malcolm Smith |
Post date | 2003-02-24T06:00:25Z |
Helen,
Based on your information I worked out how to use TIB_ConnectionSource to
add the user - thanks.
I have modified my CREATE DATABASE script so the owner is SYSDBA and GRANT's
have been given for the user MATRIX. Once the database is created I can use
TIB_Connection to add the user MATRIX and then login as MATRIX instead of
SYSDBA.
What I would like to be able to do (if possible) is:
1. Add the User MATRIX before creating the database.
2. Create the database with MATRIX as the owner.
Is it possible to configure this component so you don't need to be connected
to a database before you can add a user ?
Malcolm Smith
Analyst Programmer
Comvision Pty Ltd
http://www.comvision.org
Based on your information I worked out how to use TIB_ConnectionSource to
add the user - thanks.
I have modified my CREATE DATABASE script so the owner is SYSDBA and GRANT's
have been given for the user MATRIX. Once the database is created I can use
TIB_Connection to add the user MATRIX and then login as MATRIX instead of
SYSDBA.
What I would like to be able to do (if possible) is:
1. Add the User MATRIX before creating the database.
2. Create the database with MATRIX as the owner.
Is it possible to configure this component so you don't need to be connected
to a database before you can add a user ?
Malcolm Smith
Analyst Programmer
Comvision Pty Ltd
http://www.comvision.org