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.

Creating tables accessable to all without username prefix

3 posts in General Discussion Last posting was on 2007-08-23 22:22:30.0Z
Matt Navarret Posted on 2007-08-23 19:38:04.0Z
Sender: 56f7.46cddfc2.1804289383@sybase.com
From: Matt Navarret
Newsgroups: ianywhere.public.general
Subject: Creating tables accessable to all without username prefix
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46cde21c.5741.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Aug 2007 12:38:04 -0700
X-Trace: forums-1-dub 1187897884 10.22.241.41 (23 Aug 2007 12:38:04 -0700)
X-Original-Trace: 23 Aug 2007 12:38:04 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6228
Article PK: 4665

Currently we have all of our tables being created by a
single user let's call them userA. All of our developers
can access these tables when logged in as themselves but
they must type userA.tablename. Over the years everyone has
gotten lazy so they all log in as userA so they dont have to
type userA.tablename. I know I can create symbolic links
but that really doesn't seem necessary since the tables are
local. How do I go about creating tables that we all can
access without having to use the userA prefix. I have tried
CREATE TABLE PUBLIC.TEST but this doesn't work it tells me
that I dont have permissions to use CREATE TABLE.


Matt Navarret Posted on 2007-08-23 20:05:52.0Z
Sender: 56f7.46cddfc2.1804289383@sybase.com
From: Matt Navarret
Newsgroups: ianywhere.public.general
Subject: Re: Creating tables accessable to all without username prefix
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46cde8a0.57ee.1681692777@sybase.com>
References: <46cde21c.5741.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Aug 2007 13:05:52 -0700
X-Trace: forums-1-dub 1187899552 10.22.241.41 (23 Aug 2007 13:05:52 -0700)
X-Original-Trace: 23 Aug 2007 13:05:52 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6229
Article PK: 2638

Also I was wondering if there is a way to make it so that
any table created by any user without the schema.tablename
will be created so that all users can access the table?

> Currently we have all of our tables being created by a
> single user let's call them userA. All of our developers
> can access these tables when logged in as themselves but
> they must type userA.tablename. Over the years everyone
> has gotten lazy so they all log in as userA so they dont
> have to type userA.tablename. I know I can create
> symbolic links but that really doesn't seem necessary
> since the tables are local. How do I go about creating
> tables that we all can access without having to use the
> userA prefix. I have tried CREATE TABLE PUBLIC.TEST but
> this doesn't work it tells me that I dont have permissions
> to use CREATE TABLE.


Matt Navarret Posted on 2007-08-23 22:22:30.0Z
Sender: 56f7.46cddfc2.1804289383@sybase.com
From: Matt Navarret
Newsgroups: ianywhere.public.general
Subject: Re: Creating tables accessable to all without username prefix
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46ce08a6.59d8.1681692777@sybase.com>
References: <46cde8a0.57ee.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Aug 2007 15:22:30 -0700
X-Trace: forums-1-dub 1187907750 10.22.241.41 (23 Aug 2007 15:22:30 -0700)
X-Original-Trace: 23 Aug 2007 15:22:30 -0700, 10.22.241.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6230
Article PK: 2639

I figured out how to do it using groups. I was able to
change our userA to a group and then I added members to the
group. I had another question regarding our db application.
In our application we have userA.tablename all throughout
the code. Is that bad practice? Would it be better to just
have tablename and as we add new users just addt them to the
userA group?

> Also I was wondering if there is a way to make it so that
> any table created by any user without the schema.tablename
> will be created so that all users can access the table?
> > Currently we have all of our tables being created by a
> > single user let's call them userA. All of our
> > developers can access these tables when logged in as
> > themselves but they must type userA.tablename. Over the
> > years everyone has gotten lazy so they all log in as
> > userA so they dont have to type userA.tablename. I know
> > I can create symbolic links but that really doesn't seem
> > necessary since the tables are local. How do I go about
> > creating tables that we all can access without having to
> > use the userA prefix. I have tried CREATE TABLE
> > PUBLIC.TEST but this doesn't work it tells me that I
> > dont have permissions to use CREATE TABLE.