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
