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.

How can I change the owner of a table in IQ 12.1?

3 posts in General Discussion Last posting was on 2011-09-26 20:32:11.0Z
Greg Posted on 2011-09-26 18:46:52.0Z
Sender: 5958.4e80c24a.1804289383@sybase.com
From: greg
Newsgroups: sybase.public.iq
Subject: How can I change the owner of a table in IQ 12.1?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e80c89c.5a54.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Sep 2011 11:46:52 -0700
X-Trace: forums-1-dub 1317062812 10.22.241.41 (26 Sep 2011 11:46:52 -0700)
X-Original-Trace: 26 Sep 2011 11:46:52 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4411
Article PK: 246551

Hi, how can I change the ownership of an object in Sybase
IQ?


Thanks in advance


Greg Posted on 2011-09-26 18:49:18.0Z
Sender: 5958.4e80c24a.1804289383@sybase.com
From: greg
Newsgroups: sybase.public.iq
Subject: Re: How can I change the owner of a table in IQ 12.1?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e80c92e.5a72.1681692777@sybase.com>
References: <4e80c89c.5a54.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Sep 2011 11:49:18 -0700
X-Trace: forums-1-dub 1317062958 10.22.241.41 (26 Sep 2011 11:49:18 -0700)
X-Original-Trace: 26 Sep 2011 11:49:18 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4412
Article PK: 246552

Sorry, the release is 15.1

> Hi, how can I change the ownership of an object in Sybase
> IQ?
>
>
> Thanks in advance


Rob V Posted on 2011-09-26 20:32:11.0Z
From: Rob V <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: How can I change the owner of a table in IQ 12.1?
References: <4e80c89c.5a54.1681692777@sybase.com> <4e80c92e.5a72.1681692777@sybase.com>
In-Reply-To: <4e80c92e.5a72.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: <4e80e14b$1@forums-1-dub>
Date: 26 Sep 2011 13:32:11 -0700
X-Trace: forums-1-dub 1317069131 10.22.241.152 (26 Sep 2011 13:32:11 -0700)
X-Original-Trace: 26 Sep 2011 13:32:11 -0700, vip152.sybase.com
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4413
Article PK: 246553


On 26-Sep-2011 20:49, greg wrote:
> Sorry, the release is 15.1
>
>
>
>> Hi, how can I change the ownership of an object in Sybase
>> IQ?
>>
>>
>> Thanks in advance

You cannot. You have to create the object with the new owner and drop
the old one (if it's a table, copy the data first).

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------