Helen,

> >I will try FB 1.5 after these smart guys will get an final release. I
> >wonder if there are planned some features that are useful in MS-SQL
> >Server, like all those stored procedure implmented by the system
> >("sp_xxxx"). E.g., I miss the feature to add users via SQL
> >(the "sp_adduser" in MS-SQL Server) -
>
> Why not do it yourself? Only SYSDBA can add users, but the server's users
> all live in a database named isc4.gdb (for now...)
>
> INSERT INTO USERS(
> USER_NAME,
> PASSWD,
> FIRST_NAME,
> MIDDLE_NAME,
> LAST_NAME
> )
> VALUES(
> 'GWB',
> 'okmommy',
> 'George',
> 'Dubbya',
> 'Bush'
> );
> There's also nothing to stop SYSDBA from writing its own stored procedures
> to modify USERS.

Out of curiosity - does the above statement actually work? (that is, does
the password get encrypted??)


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."