|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I'm currently using Firebird 1.5 for Linux.
How can i check (from shell) if user already exist in database ? |
|
#2
|
||||
|
||||
|
You can connect to security.fdb and check for user existance there. Or use gsec
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
|||
|
|||
|
I've trying this :
# /opt/firebird/gsec -display user_name yes it does ... it shows us the user if user_name was exists and doesn't show if it wasn't. but i want the return value of that command which can show me that the user was exist or not. if i try this ... # echo $? either exist or not it will give us result 0 because the command was executed successfully. yesterday i was looking all day just to figure it out, but until now it wasn't solved yet. anybody has an idea ? Quote:
|
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Check if user already exist |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|