Subject | Re: Confussion over passwords: Tells me my user name and password are not define |
---|---|
Author | blizzardb2001 |
Post date | 2009-09-11T11:13:30Z |
Okay I use the Devart InterBase Data Access Components for Delphi.
But looking through the components:
e.g. TIBCConnection, TIBCTransction, TIBCQuery, TIBCTable, TIBCStoredProc, TIBCSQL, TIBCScript, TIBCUpdateSQL, TIBCDataSource, TIBCAlerter, TIBCMetaData, TIBCSQLMonitor, TIBCConnectDialog...
...I don't see anything that would help me add/remove a user in a database via gsec.
Perhaps I should explain my situation more clearly.
In my software application, the software connects using SYSDBA so it gets full permissions on everything. However, inside the database is a Staff Table with fields for all their privileges.
When the user runs the software, he must choose his user and type his password. Then the security comes from within the application. For example only 'administrators' can add new staff members.
So why not just set user to SYSDBA and password 'masterkey'?
Well, we don't want any other programmers to be able to hack into the database - they must use the password I have set up for the SYSDBA account. This was working until I copied the database to another computer. :(
But looking through the components:
e.g. TIBCConnection, TIBCTransction, TIBCQuery, TIBCTable, TIBCStoredProc, TIBCSQL, TIBCScript, TIBCUpdateSQL, TIBCDataSource, TIBCAlerter, TIBCMetaData, TIBCSQLMonitor, TIBCConnectDialog...
...I don't see anything that would help me add/remove a user in a database via gsec.
Perhaps I should explain my situation more clearly.
In my software application, the software connects using SYSDBA so it gets full permissions on everything. However, inside the database is a Staff Table with fields for all their privileges.
When the user runs the software, he must choose his user and type his password. Then the security comes from within the application. For example only 'administrators' can add new staff members.
So why not just set user to SYSDBA and password 'masterkey'?
Well, we don't want any other programmers to be able to hack into the database - they must use the password I have set up for the SYSDBA account. This was working until I copied the database to another computer. :(
--- In firebird-support@yahoogroups.com, Paul Vinkenoog <paul@...> wrote:
>
> Hi blizzrd,
>
> > Okay and what would be the way without such components?
> > Is it gsec?
>
> To create a user, yes. See the Quick Start Guide.
>
> > Is it possible to do using SQL?
>
> The short answer is: no.
>
> But let's start at the beginning: how did you create the database in
> the first place? And how do your users access it? Do you deliver an
> application? Right now it's very difficult for us to see what you want
> to achieve.
>
>
> Greetings,
> Paul Vinkenoog
>