Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Create Login as Number?

9 posts in General Discussion Last posting was on 2008-09-17 18:30:15.0Z
Trent Posted on 2008-09-10 15:22:05.0Z
Sender: 271b.48c7e567.1804289383@sybase.com
From: Trent
Newsgroups: ianywhere.public.general
Subject: Create Login as Number?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48c7e61d.2746.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Sep 2008 08:22:05 -0700
X-Trace: forums-1-dub 1221060125 10.22.241.41 (10 Sep 2008 08:22:05 -0700)
X-Original-Trace: 10 Sep 2008 08:22:05 -0700, 10.22.241.41
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7075
Article PK: 5297

Installing Sybase DB at our company and the buisness wants
the users to login with their employee number and not a user
name. Consultants say it cannot be done. Is this true?


Josh Savill Posted on 2008-09-10 15:37:57.0Z
From: Josh Savill <no_spam_jsavill@ianywhere.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Create Login as Number?
References: <48c7e61d.2746.1681692777@sybase.com>
In-Reply-To: <48c7e61d.2746.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48c7e9d5$1@forums-1-dub>
Date: 10 Sep 2008 08:37:57 -0700
X-Trace: forums-1-dub 1221061077 10.22.241.152 (10 Sep 2008 08:37:57 -0700)
X-Original-Trace: 10 Sep 2008 08:37:57 -0700, vip152.sybase.com
Lines: 12
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7076
Article PK: 5298

CREATE USER "12345" IDENTIFIED BY "12345";

worked fine for me using SQL Anywhere 11.

--
Joshua Savill
Sybase iAnywhere - Product Manager

Trent wrote:
> Installing Sybase DB at our company and the buisness wants
> the users to login with their employee number and not a user
> name. Consultants say it cannot be done. Is this true?


Jeff Albion (Sybase iAnywhere) Posted on 2008-09-10 15:57:22.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Create Login as Number?
References: <48c7e61d.2746.1681692777@sybase.com> <48c7e9d5$1@forums-1-dub>
In-Reply-To: <48c7e9d5$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48c7ee62$1@forums-1-dub>
Date: 10 Sep 2008 08:57:22 -0700
X-Trace: forums-1-dub 1221062242 10.22.241.152 (10 Sep 2008 08:57:22 -0700)
X-Original-Trace: 10 Sep 2008 08:57:22 -0700, vip152.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7078
Article PK: 5300

Note that due to the leading number in the username, Josh requires
double quotes around the username / password. (Which corresponds to our
identifier restrictions - see:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbrfen10/rf-identifiers-statement-wsqlref.html

But yes, this should work without issue. :)

Cheers,

Josh Savill wrote:
> CREATE USER "12345" IDENTIFIED BY "12345";
>
> worked fine for me using SQL Anywhere 11.

--
Jeff Albion, Product Support Analyst
Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


"Frank Ploessel" <fpl... Posted on 2008-09-10 16:34:46.0Z
Subject: Re: Create Login as Number?
From: "Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <48c7e61d.2746.1681692777@sybase.com> <48c7e9d5$1@forums-1-dub> <48c7ee62$1@forums-1-dub>
Content-Transfer-Encoding: 7bit
Message-ID: <op.ug9xn41ij0bybf@bonw00164.internal.imsglobal.com>
User-Agent: Opera Mail/9.21 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 10 Sep 2008 09:34:46 -0700
X-Trace: forums-1-dub 1221064486 10.22.241.152 (10 Sep 2008 09:34:46 -0700)
X-Original-Trace: 10 Sep 2008 09:34:46 -0700, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7079
Article PK: 5301

Hi,

In the end, useer names are just identifiers, and these either have to
obey similar rules like in other pragramming languages, or be enclosed in
double quotes or square brackets in every statement where they appear
(CONNECT, GRANT, REVOKE, but also when referencing table/procedure names
where these users are the owners). So it is possible to have numeric user
names, but a lot of care has to be taken to get all statements right.

Frank

On Wed, 10 Sep 2008 17:57:22 +0200, Jeff Albion (Sybase iAnywhere)

<firstname.lastname@ianywhere.com> wrote:

> Note that due to the leading number in the username, Josh requires
> double quotes around the username / password. (Which corresponds to our
> identifier restrictions - see:
> http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbrfen10/rf-identifiers-statement-wsqlref.html
>
> But yes, this should work without issue. :)
>
> Cheers,
>
> Josh Savill wrote:
>> CREATE USER "12345" IDENTIFIED BY "12345";
>> worked fine for me using SQL Anywhere 11.
>
>


Glenn Paulley [iablog.sybase.com/paulley] Posted on 2008-09-10 16:44:15.0Z
From: "Glenn Paulley [iablog.sybase.com/paulley]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Create Login as Number?
References: <48c7e61d.2746.1681692777@sybase.com> <48c7e9d5$1@forums-1-dub> <48c7ee62$1@forums-1-dub>
In-Reply-To: <48c7ee62$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48c7f95f$1@forums-1-dub>
Date: 10 Sep 2008 09:44:15 -0700
X-Trace: forums-1-dub 1221065055 10.22.241.152 (10 Sep 2008 09:44:15 -0700)
X-Original-Trace: 10 Sep 2008 09:44:15 -0700, vip152.sybase.com
Lines: 44
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7080
Article PK: 5302

A trivial workaround is to simply prefix all usernames with a single
character, such as "U". I have seen this approach used at other
companies who had similar requirements (employee IDs are entirely
numeric) with other software (both MS SQL Server and DB2).

Glenn

Jeff Albion (Sybase iAnywhere) wrote:
> Note that due to the leading number in the username, Josh requires
> double quotes around the username / password. (Which corresponds to our
> identifier restrictions - see:
> http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbrfen10/rf-identifiers-statement-wsqlref.html
>
>
> But yes, this should work without issue. :)
>
> Cheers,
>
> Josh Savill wrote:
>> CREATE USER "12345" IDENTIFIED BY "12345";
>>
>> worked fine for me using SQL Anywhere 11.
>
>

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Trent Carson Posted on 2008-09-17 18:20:27.0Z
Sender: 5411.48d14911.1804289383@sybase.com
From: Trent Carson
Newsgroups: ianywhere.public.general
Subject: Re: Create Login as Number?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48d14a6b.5446.1681692777@sybase.com>
References: <48c7f95f$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Sep 2008 11:20:27 -0700
X-Trace: forums-1-dub 1221675627 10.22.241.41 (17 Sep 2008 11:20:27 -0700)
X-Original-Trace: 17 Sep 2008 11:20:27 -0700, 10.22.241.41
Lines: 57
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7088
Article PK: 5309

The contracters say that it can't be done - their version
is:

Sybase Adaptive Server Enterprise/12.5.3/EBF 12599

Wouldn't the same rules apply?

> A trivial workaround is to simply prefix all usernames
> with a single character, such as "U". I have seen this
> approach used at other companies who had similar
> requirements (employee IDs are entirely numeric) with
> other software (both MS SQL Server and DB2).
>
> Glenn
>
> Jeff Albion (Sybase iAnywhere) wrote:
> > Note that due to the leading number in the username,
> > Josh requires double quotes around the username /
> > password. (Which corresponds to our identifier
> > restrictions - see:
>
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbrfen10/rf-identifiers-statement-wsqlref.html
> >
> >
> > But yes, this should work without issue. :)
> >
> > Cheers,
> >
> > Josh Savill wrote:
> >> CREATE USER "12345" IDENTIFIED BY "12345";
> >>
> >> worked fine for me using SQL Anywhere 11.
> >
> >
>
>
> --
> Glenn Paulley
> Director, Engineering (Query Processing)
> Sybase iAnywhere
>
> Blog: http://iablog.sybase.com/paulley
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://case-express.sybase.com
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the Sybase iAnywhere pages at
>

http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Josh Savill Posted on 2008-09-17 18:27:27.0Z
From: Josh Savill <no_spam_jsavill@ianywhere.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Create Login as Number?
References: <48c7f95f$1@forums-1-dub> <48d14a6b.5446.1681692777@sybase.com>
In-Reply-To: <48d14a6b.5446.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48d14c0f$1@forums-1-dub>
Date: 17 Sep 2008 11:27:27 -0700
X-Trace: forums-1-dub 1221676047 10.22.241.152 (17 Sep 2008 11:27:27 -0700)
X-Original-Trace: 17 Sep 2008 11:27:27 -0700, vip152.sybase.com
Lines: 64
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7089
Article PK: 5310

I cannot specifically answer that question as this forum is designed for
SQL Anywhere and other iAnywhere products.

You can get more information posting a question in the
sybase.public.ase.general newsgroup.

--
Joshua Savill
Sybase iAnywhere - Product Manager

Trent Carson wrote:
> The contracters say that it can't be done - their version
> is:
>
> Sybase Adaptive Server Enterprise/12.5.3/EBF 12599
>
> Wouldn't the same rules apply?
>
>
>
>> A trivial workaround is to simply prefix all usernames
>> with a single character, such as "U". I have seen this
>> approach used at other companies who had similar
>> requirements (employee IDs are entirely numeric) with
>> other software (both MS SQL Server and DB2).
>>
>> Glenn
>>
>> Jeff Albion (Sybase iAnywhere) wrote:
>>> Note that due to the leading number in the username,
>>> Josh requires double quotes around the username /
>>> password. (Which corresponds to our identifier
>>> restrictions - see:
> http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbrfen10/rf-identifiers-statement-wsqlref.html
>>>
>>> But yes, this should work without issue. :)
>>>
>>> Cheers,
>>>
>>> Josh Savill wrote:
>>>> CREATE USER "12345" IDENTIFIED BY "12345";
>>>>
>>>> worked fine for me using SQL Anywhere 11.
>>>
>>
>> --
>> Glenn Paulley
>> Director, Engineering (Query Processing)
>> Sybase iAnywhere
>>
>> Blog: http://iablog.sybase.com/paulley
>>
>> EBF's and Patches: http://downloads.sybase.com
>> choose SQL Anywhere Studio >> change 'time frame' to all
>>
>> To Submit Bug Reports: http://case-express.sybase.com
>>
>> SQL Anywhere Studio Supported Platforms and Support Status
>> http://my.sybase.com/detail?id=1002288
>>
>> Whitepapers, TechDocs, and bug fixes are all available
>> through the Sybase iAnywhere pages at
>>
> http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Glenn Paulley [iablog.sybase.com/paulley] Posted on 2008-09-17 18:30:15.0Z
From: "Glenn Paulley [iablog.sybase.com/paulley]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Create Login as Number?
References: <48c7f95f$1@forums-1-dub> <48d14a6b.5446.1681692777@sybase.com>
In-Reply-To: <48d14a6b.5446.1681692777@sybase.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48d14cb7$1@forums-1-dub>
Date: 17 Sep 2008 11:30:15 -0700
X-Trace: forums-1-dub 1221676215 10.22.241.152 (17 Sep 2008 11:30:15 -0700)
X-Original-Trace: 17 Sep 2008 11:30:15 -0700, vip152.sybase.com
Lines: 95
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7090
Article PK: 5311

As far as I can tell, the answer is yes. Here is the relevant text from
the ASE 12.5 reference manual, volume 1 (building blocks), page 230:

Adaptive Server identifiers can be a maximum of 30 bytes in length,
whether single-byte or multibyte characters are used. The first
character of an identifier must be either an alphabetic character, as
defined in the current character set, or the underscore (_) character.

Note; Temporary table names, which begin with the pound sign (#), and
local variable names, which begin with the at sign (@), are exceptions
to this rule.

Subsequent characters can include letters, numbers, the symbols #, @, _,
and currency symbols such as $ (dollars), ¥ (yen), and £ (pound
sterling). Identifiers cannot include special characters such as !, %,
^, &, *, and . or embedded spaces. You cannot use a reserved word, such
as a Transact-SQL command, as an identifier. For a complete list of
reserved words, see Chapter 5, “Reserved Words.”

Glenn

Trent Carson wrote:
> The contracters say that it can't be done - their version
> is:
>
> Sybase Adaptive Server Enterprise/12.5.3/EBF 12599
>
> Wouldn't the same rules apply?
>
>
>
>> A trivial workaround is to simply prefix all usernames
>> with a single character, such as "U". I have seen this
>> approach used at other companies who had similar
>> requirements (employee IDs are entirely numeric) with
>> other software (both MS SQL Server and DB2).
>>
>> Glenn
>>
>> Jeff Albion (Sybase iAnywhere) wrote:
>>> Note that due to the leading number in the username,
>>> Josh requires double quotes around the username /
>>> password. (Which corresponds to our identifier
>>> restrictions - see:
> http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbrfen10/rf-identifiers-statement-wsqlref.html
>>>
>>> But yes, this should work without issue. :)
>>>
>>> Cheers,
>>>
>>> Josh Savill wrote:
>>>> CREATE USER "12345" IDENTIFIED BY "12345";
>>>>
>>>> worked fine for me using SQL Anywhere 11.
>>>
>>
>> --
>> Glenn Paulley
>> Director, Engineering (Query Processing)
>> Sybase iAnywhere
>>
>> Blog: http://iablog.sybase.com/paulley
>>
>> EBF's and Patches: http://downloads.sybase.com
>> choose SQL Anywhere Studio >> change 'time frame' to all
>>
>> To Submit Bug Reports: http://case-express.sybase.com
>>
>> SQL Anywhere Studio Supported Platforms and Support Status
>> http://my.sybase.com/detail?id=1002288
>>
>> Whitepapers, TechDocs, and bug fixes are all available
>> through the Sybase iAnywhere pages at
>>
> http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Chris Keating (Sybase iAnywhere) Posted on 2008-09-10 15:54:59.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Create Login as Number?
References: <48c7e61d.2746.1681692777@sybase.com>
In-Reply-To: <48c7e61d.2746.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48c7edd3$1@forums-1-dub>
Date: 10 Sep 2008 08:54:59 -0700
X-Trace: forums-1-dub 1221062099 10.22.241.152 (10 Sep 2008 08:54:59 -0700)
X-Original-Trace: 10 Sep 2008 08:54:59 -0700, vip152.sybase.com
Lines: 36
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7077
Article PK: 5299

From the docs:

A password can be either a valid identifier, as described in
Identifiers, or a string (maximum 255 bytes) placed in single quotes.
Passwords are case sensitive. It is recommended that the password be
composed of 7-bit ASCII characters, as other characters may not work
correctly if the database server cannot convert from the client's
character set to UTF-8.

The trick is that a number is not a valid identifier so will fail when
not quoted. You can login using that UID in our tools but may need to be
attentive to that requirement when making connections from your application.

For more info, consult the documentation using index tab seaches for
GRANT CONNECT and identifiers.
--

Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

Trent wrote:
> Installing Sybase DB at our company and the buisness wants
> the users to login with their employee number and not a user
> name. Consultants say it cannot be done. Is this true?