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.

Change values of system tables in ASA

5 posts in General Discussion Last posting was on 2006-09-15 17:22:11.0Z
Luis C Posted on 2006-09-14 23:22:37.0Z
Sender: 296b.4509e3ea.1804289383@sybase.com
From: Luis C
Newsgroups: ianywhere.public.general
Subject: Change values of system tables in ASA
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4509e411.296d.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 14 Sep 2006 16:21:53 -0700, 10.22.241.42
Lines: 4
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 14 Sep 2006 16:21:54 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 14 Sep 2006 16:22:37 -0700
X-Trace: forums-1-dub 1158276157 10.22.108.75 (14 Sep 2006 16:22:37 -0700)
X-Original-Trace: 14 Sep 2006 16:22:37 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5623
Article PK: 1646

Hi, Anyone know if is it posible to change the values of the
"SYS*" tables in ASA 9.0.2.?

Thanks!!!


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-09-15 00:29:40.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Change values of system tables in ASA
References: <4509e411.296d.1681692777@sybase.com>
In-Reply-To: <4509e411.296d.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vpneast-client-032.sybase.com
X-Original-NNTP-Posting-Host: vpneast-client-032.sybase.com
Message-ID: <4509f3f4$1@forums-1-dub>
Date: 14 Sep 2006 17:29:40 -0700
X-Trace: forums-1-dub 1158280180 10.18.242.39 (14 Sep 2006 17:29:40 -0700)
X-Original-Trace: 14 Sep 2006 17:29:40 -0700, vpneast-client-032.sybase.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5624
Article PK: 1648

You generally need to use ALTER... statements to modify system tables.
What are you trying to do?
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Luis C Posted on 2006-09-15 14:24:50.0Z
Sender: 296b.4509e3ea.1804289383@sybase.com
From: Luis C
Newsgroups: ianywhere.public.general
Subject: Re: Change values of system tables in ASA
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <450ab783.32a2.1681692777@sybase.com>
References: <4509f3f4$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 15 Sep 2006 07:24:03 -0700, 10.22.241.42
Lines: 43
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Sep 2006 07:24:04 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Sep 2006 07:24:50 -0700
X-Trace: forums-1-dub 1158330290 10.22.108.75 (15 Sep 2006 07:24:50 -0700)
X-Original-Trace: 15 Sep 2006 07:24:50 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5625
Article PK: 1649

Hi Chris. I'm trying to change some values of one row of the
table sys.sysremoteuser, but I don't have sufficient
permissions.

I want to know if exist a way to give the DBA user the
permissions to modify this values, or how I can do this
task?

Thanks

Luis C

> You generally need to use ALTER... statements to modify
> system tables. What are you trying to do?
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> **********************************************************
> *******************
>
> Sign up today for your copy of the SQL Anywhere Studio 9
> Developer Edition =and try out the market-leading
> database for mobile, embedded and small to medium sized
> business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> **********************************************************
> *******************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at
> http://www.iAnywhere.com/developer ** EBFs can be found at
> http://downloads.sybase.com/swx/sdmain.stm ** Use Case
> Express to report bugs http://case-express.sybase.com
>
> **********************************************************
> *******************


Reg Domaratzki (iAnywhere Solutions) Posted on 2006-09-15 14:27:36.0Z
From: "Reg Domaratzki \(iAnywhere Solutions\)" <FirstName.LastName@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4509f3f4$1@forums-1-dub> <450ab783.32a2.1681692777@sybase.com>
Subject: Re: Change values of system tables in ASA
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: rdomarat-xp.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-xp.sybase.com
Message-ID: <450ab858$1@forums-1-dub>
Date: 15 Sep 2006 07:27:36 -0700
X-Trace: forums-1-dub 1158330456 10.25.99.188 (15 Sep 2006 07:27:36 -0700)
X-Original-Trace: 15 Sep 2006 07:27:36 -0700, rdomarat-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5626
Article PK: 1652

No, you cannot change values in this table.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

<Luis C> wrote in message news:450ab783.32a2.1681692777@sybase.com...
> Hi Chris. I'm trying to change some values of one row of the
> table sys.sysremoteuser, but I don't have sufficient
> permissions.
>
> I want to know if exist a way to give the DBA user the
> permissions to modify this values, or how I can do this
> task?
>
> Thanks
>
> Luis C
>
>> You generally need to use ALTER... statements to modify
>> system tables. What are you trying to do?
>> --
>>
>> Chris Keating
>> Sybase Adaptive Server Anywhere Professional Version 8
>>
>> **********************************************************
>> *******************
>>
>> Sign up today for your copy of the SQL Anywhere Studio 9
>> Developer Edition =and try out the market-leading
>> database for mobile, embedded and small to medium sized
>> business environments for free!
>>
>> http://www.ianywhere.com/promos/deved/index.html
>>
>> **********************************************************
>> *******************
>>
>> iAnywhere Solutions http://www.iAnywhere.com
>>
>> ** Please only post to the newsgroup
>>
>> ** Whitepapers can be found at
>> http://www.iAnywhere.com/developer ** EBFs can be found at
>> http://downloads.sybase.com/swx/sdmain.stm ** Use Case
>> Express to report bugs http://case-express.sybase.com
>>
>> **********************************************************
>> *******************