Subject | Retrieve user informationen via SQL |
---|---|
Author | Robert Zimmermann |
Post date | 2006-05-11T15:16:53Z |
Hello @all!
I'm just hacking together an easy-to-use database interface for firebird
using C++ and ADO. I'm currently working on a code to retrieve different
informations from the database. Since ADO functionality is sometimes too
driver-dependant (OpenSchema f.e) I wanted to use the system tables of
firebird. I can't find no system table for:
a) all registered users
b) users loggend in
Is there a way to retrieve such information using SQL ? And there's another
problem regarding the views: Is a views sourcecode stored somewhere I am
able to retrieve it by SQL? I saw a couple of tools that were able to get
the sourcecode of my view but I couldn't find it in any of the system
tables.
Greetingz,
Robert
--
Echte DSL-Flatrate dauerhaft f�r 0,- Euro*!
"Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl
I'm just hacking together an easy-to-use database interface for firebird
using C++ and ADO. I'm currently working on a code to retrieve different
informations from the database. Since ADO functionality is sometimes too
driver-dependant (OpenSchema f.e) I wanted to use the system tables of
firebird. I can't find no system table for:
a) all registered users
b) users loggend in
Is there a way to retrieve such information using SQL ? And there's another
problem regarding the views: Is a views sourcecode stored somewhere I am
able to retrieve it by SQL? I saw a couple of tools that were able to get
the sourcecode of my view but I couldn't find it in any of the system
tables.
Greetingz,
Robert
--
Echte DSL-Flatrate dauerhaft f�r 0,- Euro*!
"Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl