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.

changing object ownership

3 posts in General Discussion Last posting was on 2003-11-21 15:56:40.0Z
Frank Burleigh Posted on 2003-11-19 17:04:31.0Z
From: Frank Burleigh <burleigh@indiana.edu>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031119
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: changing object ownership
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bluebox.law.indiana.edu
X-Original-NNTP-Posting-Host: bluebox.law.indiana.edu
Message-ID: <3fbba29f$1@forums-1-dub>
Date: 19 Nov 2003 09:04:31 -0800
X-Trace: forums-1-dub 1069261471 129.79.131.136 (19 Nov 2003 09:04:31 -0800)
X-Original-Trace: 19 Nov 2003 09:04:31 -0800, bluebox.law.indiana.edu
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2107
Article PK: 4322

As a user with DBA, I've created a bunch of tables in a development db.
These of course now belong to me and everything works well while I'm
logged in to the db as me. But when I'm someone else...well, there are
issues. ;-)

I see that the best creator of an object is a group, but that's awfully
inconvenient unless the group is allowed to connect. (Am I wrong?).

So, is there a way to change ownership of tables and things? I'd want
to give ownership to a group in which the users will have membership.

Thanks.
--
Frank Burleigh
Indiana University School of Law
burleigh@indiana.edu


Chris Keating (iAnywhere Solutions) Posted on 2003-11-19 18:29:52.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <3fbba29f$1@forums-1-dub>
Subject: Re: changing object ownership
Lines: 70
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <3fbbb6a0$1@forums-1-dub>
Date: 19 Nov 2003 10:29:52 -0800
X-Trace: forums-1-dub 1069266592 172.31.141.1 (19 Nov 2003 10:29:52 -0800)
X-Original-Trace: 19 Nov 2003 10:29:52 -0800, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2108
Article PK: 4325

You do not need to be logged in as the owner of the table to create the
table. As a dba, you can create the object. For example, you have defined a
group named "group". As the dba, you can create a table "t" owned by "group"
as follows:

create group.t (
id integer
).

A quick fix is to convert your userid to a group and assign users to that
group. This will allow the users visibility of the tables without qualifying
table ownership. For example, select * from t rather than select * from
owner.t

The role of dba will not be inherited by members of a group that has DBA
authorities.

Alternately, you can unload you database, modify the schema to reflect the
ownership and rebuild a new database based on the changed schema.




--

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 CaseXpress to report bugs http://casexpress.sybase.com

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

"Frank Burleigh" <burleigh@indiana.edu> wrote in message
news:3fbba29f$1@forums-1-dub...
> As a user with DBA, I've created a bunch of tables in a development db.
> These of course now belong to me and everything works well while I'm
> logged in to the db as me. But when I'm someone else...well, there are
> issues. ;-)
>
> I see that the best creator of an object is a group, but that's awfully
> inconvenient unless the group is allowed to connect. (Am I wrong?).
>
> So, is there a way to change ownership of tables and things? I'd want
> to give ownership to a group in which the users will have membership.
>
> Thanks.
> --
> Frank Burleigh
> Indiana University School of Law
> burleigh@indiana.edu


Frank Burleigh Posted on 2003-11-21 15:56:40.0Z
From: Frank Burleigh <burleigh@indiana.edu>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031121
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: changing object ownership
References: <3fbba29f$1@forums-1-dub> <3fbbb6a0$1@forums-1-dub>
In-Reply-To: <3fbbb6a0$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bluebox.law.indiana.edu
X-Original-NNTP-Posting-Host: bluebox.law.indiana.edu
Message-ID: <3fbe35b8$1@forums-1-dub>
Date: 21 Nov 2003 07:56:40 -0800
X-Trace: forums-1-dub 1069430200 129.79.131.136 (21 Nov 2003 07:56:40 -0800)
X-Original-Trace: 21 Nov 2003 07:56:40 -0800, bluebox.law.indiana.edu
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2118
Article PK: 4334

Thanks Chris, that is excellent and very helpful information!

Chris Keating (iAnywhere Solutions) wrote:
> You do not need to be logged in as the owner of the table to create the
> table. As a dba, you can create the object. For example, you have defined a
> group named "group". As the dba, you can create a table "t" owned by "group"
> as follows:

[snip]

--
Frank Burleigh
Indiana University School of Law
burleigh@indiana.edu