faqts : Computers : Databases : Firebird

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

2 of 2 people (100%) answered Yes
Recently 2 of 2 people (100%) answered Yes

Entry

How do i create a USER FROM the ISQL prompt If i am not using an EMS OR external SOFTWARE

Jun 21st, 2005 08:23
George Boutwell, Rita Rao,


You don't use ISQL, you use GSEC but it should be part of the FireBird
install, and to use GSEC the command would look something like this:

<path to FireBirad Install>\bin\gsec -user sysdba -password masterkey
-database localhost:d:\fbsql\security.fdb
			
Once in GSEC...  you have a prompt: GSEC>
GSEC>	Add dbuser -pw yourpassword -fname fullname   	
GSEC>	display
GSEC>	quit