SQLBase 12 valid password characters?

Discussion forum about all things SqlBase.
StefanM
Germany
Posts: 677
Joined: 10 Aug 2018, 15:57
Location: Bavaria

SQLBase 12 valid password characters?

Post by StefanM » 10 Nov 2020, 16:44

Hi SQLBase gurus,

does anybody know which characters are allowed to be used for passwords? I didn't find any hint in the documentation. Just all characters?

Thanks,
Stefan

StefanM
Germany
Posts: 677
Joined: 10 Aug 2018, 15:57
Location: Bavaria

Re: SQLBase 12 valid password characters?

Post by StefanM » 10 Nov 2020, 18:32

Hi All,

found it myself:

A password is also an "short identifier" (nowhere explained what this means)
see SQLBase Language Reference, chapters
- Names => password (here: "...It is case-sensitive..." !!!)
- GRANT (Database Authority)
- ALTER PASSWORD
- short identifier: nowhere expained what this means (only in "New Features", chp. "Longer Password Support" => 32 chars since SQLBase 11.5)

So besides a-z, A-Z and 0-9 only #, $, %, @ and _ are allowed special charaters.


BUT with SQLBase 12.2.1 it seems that password is *not case-sensitive":

connect ISLAND;
-- even enclosing password in double quotes to get a qualified name makes no difference
grant connect to TST identified by "tst";
disconnect all;

connect ISLAND TST/TST;
=> user TST is connected !!!

I checked "Database Administrator's Guide" for a SQL.INI keyword about case-sensitivity but found none.

Stefan

FRBhote
India
Posts: 2172
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: SQLBase 12 valid password characters?

Post by FRBhote » 11 Nov 2020, 05:11

I don't think it was ever case sensitive - and I like it!

EwaldP
Austria
Posts: 339
Joined: 07 Mar 2017, 08:00
Location: Austria

Re: SQLBase 12 valid password characters?

Post by EwaldP » 11 Nov 2020, 07:29

Have been working with SQLBase since the 16 bit version. Password was never case sensitive (definitely in versions 6.1, 8,1, 9.0, 11.6, 11.7, 12.0, 12.1).
Ewald P. Palmetshofer
EDV-Hausleitner GmbH
4020 Linz
www.edv-hausleitner.at

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest