|Subject||Re: Re: Retrieve user information via SQL|
> Message 9Hm ok, it's just because I saw something like that on oracle (a system view
> From: "Adam" s3057043@...
> Date: Thu May 11, 2006 4:47pm(PDT)
> Subject: Re: Retrieve user informationen via SQL
> > ( ... )
> > I can't find no system table for:
> > a) all registered users
> Users are registered to a server, not a database. Users are granted
> roles, and those roles are granted permissions to insert / delete /
> update / execute etc to the different database objects.
showing all users as far as I remember).
> I would suggest you do not reinvent the wheel. There is already anRight, but I wanted to have a fully functional interface that is capable to
> interface that wraps the API with C++ classes, so look at that before
> you spend to much time.
connect to other databases as well. And so I'm writing a) a common
base-interface and b) changeable .dll "plugins" for database specific stuff
(like the database information retrieval I mentioned before). This also is a
learning project. I'm interested in how all that database stuff works. Sure,
somebody has done this before.
> RDB$RELATIONS.RDB$VIEW_SOURCEOk thanks. I just wanted to retrieve the code to alter it using an editor.
> However this is optional. The code that is executed by the server is
> actually in the field RDB$VIEW_BLR (a sort of compiled SQL), so it is
> possible to remove the view source and retain a functioning database
> (but don't do this unless it is absolutely essential, just letting you
> know it may not always be present).
So I guess it's okay. I never would modify the system tables myself.
GMX Produkte empfehlen und ganz einfach Geld verdienen!
Satte Provisionen f�r GMX Partner: http://www.gmx.net/de/go/partner