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.

Where to go to change the default UID & PWD for database

7 posts in General Discussion Last posting was on 2004-07-28 20:57:04.0Z
J Riley Posted on 2004-07-27 18:15:30.0Z
Sender: 6006.41069be3.1804289383@sybase.com
From: J Riley
Newsgroups: ianywhere.public.general
Subject: Where to go to change the default UID & PWD for database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41069cc8.6012.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 27 Jul 2004 11:19:52 -0700, 10.22.241.42
Lines: 6
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 Jul 2004 11:08:14 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 Jul 2004 11:15:30 -0700
X-Trace: forums-1-dub 1090952130 10.22.108.75 (27 Jul 2004 11:15:30 -0700)
X-Original-Trace: 27 Jul 2004 11:15:30 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3328
Article PK: 7239

ASA 7.0

Like the title says, where specifically do I go to change
the default UID & PWD? Will this roll down to other
databases on the same service, or is each DB done
individually?


Nick Elson Posted on 2004-07-27 18:45:38.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <41069cc8.6012.1681692777@sybase.com>
Subject: Re: Where to go to change the default UID & PWD for database
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <4106a2d2$1@forums-1-dub>
Date: 27 Jul 2004 11:45:38 -0700
X-Trace: forums-1-dub 1090953938 10.25.100.226 (27 Jul 2004 11:45:38 -0700)
X-Original-Trace: 27 Jul 2004 11:45:38 -0700, nicelson-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3329
Article PK: 7237

Each DB needs to be done individually.

In dbisql you reissue the

GRANT CONNECT TO <UID> IDENTIFIED BY <NEW_PWD>;

In Sybase Central navigate to the user and change the password from
the user's properties by 'RightMouseClick'ing on the user (in either pane)
and picking "Properties" from the pop-up menu.

<J Riley> wrote in message news:41069cc8.6012.1681692777@sybase.com...
> ASA 7.0
>
> Like the title says, where specifically do I go to change
> the default UID & PWD? Will this roll down to other
> databases on the same service, or is each DB done
> individually?


J Riley Posted on 2004-07-27 19:01:17.0Z
Sender: 2f75.4106a620.1804289383@sybase.com
From: J Riley
Newsgroups: ianywhere.public.general
Subject: Re: Where to go to change the default UID & PWD for database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4106a67d.2f86.1681692777@sybase.com>
References: <4106a2d2$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Jul 2004 12:01:17 -0700
X-Trace: forums-1-dub 1090954877 10.22.241.41 (27 Jul 2004 12:01:17 -0700)
X-Original-Trace: 27 Jul 2004 12:01:17 -0700, 10.22.241.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3330
Article PK: 7238

Now, this is to change from DBA & SQL for the database, not
for a user, correct?

> Each DB needs to be done individually.
>
> In dbisql you reissue the
>
> GRANT CONNECT TO <UID> IDENTIFIED BY <NEW_PWD>;
>
> In Sybase Central navigate to the user and change the
> password from the user's properties by
> 'RightMouseClick'ing on the user (in either pane) and
> picking "Properties" from the pop-up menu.
>
>
>
> <J Riley> wrote in message
> > news:41069cc8.6012.1681692777@sybase.com... ASA 7.0
> >
> > Like the title says, where specifically do I go to
> > change the default UID & PWD? Will this roll down to
> > other databases on the same service, or is each DB done
> > individually?
>
>


Breck Carter [TeamSybase] Posted on 2004-07-27 19:24:48.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Where to go to change the default UID & PWD for database
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <daadg01bbatanlkq6h0b8j73h8ur09cnq9@4ax.com>
References: <4106a2d2$1@forums-1-dub> <4106a67d.2f86.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 12.24.172.2
X-Original-Trace: 27 Jul 2004 12:29:11 -0700, 12.24.172.2
Lines: 40
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 Jul 2004 12:17:32 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 Jul 2004 12:24:48 -0700
X-Trace: forums-1-dub 1090956288 10.22.108.75 (27 Jul 2004 12:24:48 -0700)
X-Original-Trace: 27 Jul 2004 12:24:48 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3331
Article PK: 7240

DBA *is* a user, just like any other, except it also has the magic
"DBA" privilege. The DBA/SQL combination just happens to be the only
user id that is set up on a brand new default database. Lots of folks
continue to use it as the main (or only) user id. If you are at all
concerned about security, the password should be changed at least.

On 27 Jul 2004 12:01:17 -0700, J Riley wrote:

>Now, this is to change from DBA & SQL for the database, not
>for a user, correct?
>
>> Each DB needs to be done individually.
>>
>> In dbisql you reissue the
>>
>> GRANT CONNECT TO <UID> IDENTIFIED BY <NEW_PWD>;
>>
>> In Sybase Central navigate to the user and change the
>> password from the user's properties by
>> 'RightMouseClick'ing on the user (in either pane) and
>> picking "Properties" from the pop-up menu.
>>
>>
>>
>> <J Riley> wrote in message
>> > news:41069cc8.6012.1681692777@sybase.com... ASA 7.0
>> >
>> > Like the title says, where specifically do I go to
>> > change the default UID & PWD? Will this roll down to
>> > other databases on the same service, or is each DB done
>> > individually?
>>
>>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


J Riley Posted on 2004-07-28 20:54:15.0Z
Sender: 6f82.4108129f.1804289383@sybase.com
From: J Riley
Newsgroups: ianywhere.public.general
Subject: Re: Where to go to change the default UID & PWD for database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41081381.6f9a.1681692777@sybase.com>
References: <daadg01bbatanlkq6h0b8j73h8ur09cnq9@4ax.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 28 Jul 2004 13:58:41 -0700, 10.22.241.42
Lines: 16
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Jul 2004 13:46:52 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Jul 2004 13:54:15 -0700
X-Trace: forums-1-dub 1091048055 10.22.108.75 (28 Jul 2004 13:54:15 -0700)
X-Original-Trace: 28 Jul 2004 13:54:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3339
Article PK: 7245

It is also set up as a group on our DB/Service, to which
every user belongs.

And that is precisely why we are changing it,
Sarbanes-Oxley. Too bad Sarbanes-Oxley wouldn't mandate to
our boss our need for a dedicated DBA instead of 1/2
literate developers ;)

Thanks for the help!

> DBA *is* a user, just like any other, except it also has
> the magic "DBA" privilege. The DBA/SQL combination just
> happens to be the only user id that is set up on a brand
> new default database. Lots of folks continue to use it as
> the main (or only) user id. If you are at all concerned
> about security, the password should be changed at least.


Greg Fenton Posted on 2004-07-27 20:15:40.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20040707)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Where to go to change the default UID & PWD for database
References: <41069cc8.6012.1681692777@sybase.com>
In-Reply-To: <41069cc8.6012.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <4106b7ec$1@forums-1-dub>
Date: 27 Jul 2004 13:15:40 -0700
X-Trace: forums-1-dub 1090959340 10.25.100.188 (27 Jul 2004 13:15:40 -0700)
X-Original-Trace: 27 Jul 2004 13:15:40 -0700, gfenton-xp.sybase.com
Lines: 28
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3332
Article PK: 7242

Along with what Breck and Chris have pointed out, recognize that any
DBA-privileged user can grant DBA authority to any other user in the
database.

From a security standpoint, it might be best to *not* have a user named
"DBA" as this is the default DBA user. You could simply revoke DBA's
CONNECT privileges. (Many Unix security experts change the name of
their "root" account since that is one less piece of information
potential hackers would have).

Another thing you might be interested in if you are managing lots of
databases is the concept of INTEGRATED LOGINS. In the ASA 7.x online
docs, see:

ASA Adaptive Server Anywhere User's Guide
PART 1. Starting and Connecting to Your Database
CHAPTER 2. Connecting to a Database
- Using integrated logins

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


J Riley Posted on 2004-07-28 20:57:04.0Z
Sender: 6f9f.410813a7.1804289383@sybase.com
From: J Riley
Newsgroups: ianywhere.public.general
Subject: Re: Where to go to change the default UID & PWD for database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41081427.6fab.1681692777@sybase.com>
References: <4106b7ec$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 28 Jul 2004 14:01:27 -0700, 10.22.241.42
Lines: 31
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Jul 2004 13:49:38 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Jul 2004 13:57:04 -0700
X-Trace: forums-1-dub 1091048224 10.22.108.75 (28 Jul 2004 13:57:04 -0700)
X-Original-Trace: 28 Jul 2004 13:57:04 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3340
Article PK: 7248

Thanks very much! I appreciate all the help!

> Along with what Breck and Chris have pointed out,
> recognize that any DBA-privileged user can grant DBA
> authority to any other user in the database.
>
> From a security standpoint, it might be best to *not*
> have a user named "DBA" as this is the default DBA user.
> You could simply revoke DBA's CONNECT privileges. (Many
> Unix security experts change the name of their "root"
> account since that is one less piece of information
> potential hackers would have).
>
> Another thing you might be interested in if you are
> managing lots of databases is the concept of INTEGRATED
> LOGINS. In the ASA 7.x online docs, see:
>
> ASA Adaptive Server Anywhere User's Guide
> PART 1. Starting and Connecting to Your Database
> CHAPTER 2. Connecting to a Database
> - Using integrated logins
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/