Thank you Paul,

That is helpful.  I didn't realize this was possible outside of GSec.

Rick

-----Original Message-----
From: Mercea Paul [mailto:paul.mer...@almexa.ro] 
Sent: Monday, January 10, 2011 2:42 PM
To: firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] SPAM-LOW: Re: FBSecurity UserPassword

Hi Rick
> I am trying to write a utility program to add/update/delete users from the
database, but I don't always know their password so it seems like Update
would be impossible.
>
You can use :
CREATE USER <username> {PASSWORD 'password'} [FIRSTNAME 'firstname']
[MIDDLENAME 'middlename'] [LASTNAME 'lastname'] [GRANT ADMIN ROLE];

ALTER USER <username>
[PASSWORD 'password']
[FIRSTNAME 'firstname']
[MIDDLENAME 'middlename']
[LASTNAME 'lastname']
[{GRANT | REVOKE} ADMIN ROLE];

DROP USER <username>;

Try to use this functionality for yout utility program!

Check Firebird_v2.5.0.ReleaseNotes.pdf on page 45 !

Regards,
Mercea Paul




----------------------------------------------------------------------------
--
Gaining the trust of online customers is vital for the success of any
company
that requires sensitive data to be transmitted over the Web.   Learn how to 
best implement a security strategy that keeps consumers' information secure
and instills the confidence they need to proceed with transactions.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


------------------------------------------------------------------------------
Gaining the trust of online customers is vital for the success of any company
that requires sensitive data to be transmitted over the Web.   Learn how to 
best implement a security strategy that keeps consumers' information secure 
and instills the confidence they need to proceed with transactions.
http://p.sf.net/sfu/oracle-sfdevnl 
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to