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.

bcp'ing syssrvroles

3 posts in General Discussion Last posting was on 2010-01-19 16:37:12.0Z
John Flynn Posted on 2010-01-18 21:30:23.0Z
From: "John Flynn" <jflynn@miqs.com>
Newsgroups: sybase.public.ase.general
Subject: bcp'ing syssrvroles
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b54d2ef$1@forums-1-dub>
Date: 18 Jan 2010 13:30:23 -0800
X-Trace: forums-1-dub 1263850223 10.22.241.152 (18 Jan 2010 13:30:23 -0800)
X-Original-Trace: 18 Jan 2010 13:30:23 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28891
Article PK: 78134

Hi.

For decades, I've been accustomed to bulk-copying two particular tables from
one ASE to another when migrating/cloning a database and its users. These
are syslogins and sysloginroles. I do the bcp-in using the -b1 option so
that sa and probe fail out rather than getting imported into the new
database. (I could be wrong but I think maybe even the ASE manual approves
this technique.)

Recently I've started creating user-defined roles. The user assignments will
come over as part of sysloginroles. But I also need the entries in
syssrvroles to come over. So I think I need to add syssrvroles as one of the
tables I routinely copy over during a migration. But syssrvroles also
contains a whole collection of system-defined roles, like sa_role and
sso_role and a dozen others. Should I continue to use -b1 so that the system
entries don't get overwritten (due to the uniqueness constraint on srid)? Or
should I overwrite all the syssrvroles roles in? Or is this the wrong method
to be using on syssrvroles in the first place?

Why does it seem like when people on the newsgroup discuss the migration
issue, they always mention syslogins and sysloginroles, but never
syssrvroles? Is it that not many people use user-defined roles? Or maybe
they deal with them differently than the other two tables?

Thanks.
- John.


Vivek Kak Posted on 2010-01-19 02:13:10.0Z
Sender: 1f69.4b551347.1804289383@sybase.com
From: Vivek Kak
Newsgroups: sybase.public.ase.general
Subject: Re: bcp'ing syssrvroles
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b551536.1f8f.1681692777@sybase.com>
References: <4b54d2ef$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jan 2010 18:13:10 -0800
X-Trace: forums-1-dub 1263867190 10.22.241.41 (18 Jan 2010 18:13:10 -0800)
X-Original-Trace: 18 Jan 2010 18:13:10 -0800, 10.22.241.41
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28893
Article PK: 78135

Hi John,

I have been using the -b1 technique for syssrvroles as in
our environment we do use user defined roles and it has
always worked for me without any issues .

HTH,
Vivek

> Hi.
>
> For decades, I've been accustomed to bulk-copying two
> particular tables from one ASE to another when
> migrating/cloning a database and its users. These are
> syslogins and sysloginroles. I do the bcp-in using the -b1
> option so that sa and probe fail out rather than getting
> imported into the new database. (I could be wrong but I
> think maybe even the ASE manual approves this technique.)
>
> Recently I've started creating user-defined roles. The
> user assignments will come over as part of sysloginroles.
> But I also need the entries in syssrvroles to come over.
> So I think I need to add syssrvroles as one of the tables
> I routinely copy over during a migration. But syssrvroles
> also contains a whole collection of system-defined roles,
> like sa_role and sso_role and a dozen others. Should I
> continue to use -b1 so that the system entries don't get
> overwritten (due to the uniqueness constraint on srid)? Or
> should I overwrite all the syssrvroles roles in? Or is
> this the wrong method to be using on syssrvroles in the
> first place?
>
> Why does it seem like when people on the newsgroup discuss
> the migration issue, they always mention syslogins and
> sysloginroles, but never syssrvroles? Is it that not many
> people use user-defined roles? Or maybe they deal with
> them differently than the other two tables?
>
> Thanks.
> - John.
>
>


John Flynn Posted on 2010-01-19 16:37:12.0Z
From: "John Flynn" <jflynn@miqs.com>
Newsgroups: sybase.public.ase.general
References: <4b54d2ef$1@forums-1-dub> <4b551536.1f8f.1681692777@sybase.com>
Subject: Re: bcp'ing syssrvroles
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b55dfb8$3@forums-1-dub>
Date: 19 Jan 2010 08:37:12 -0800
X-Trace: forums-1-dub 1263919032 10.22.241.152 (19 Jan 2010 08:37:12 -0800)
X-Original-Trace: 19 Jan 2010 08:37:12 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28898
Article PK: 78140


Vivek Kak wrote:
> I have been using the -b1 technique for syssrvroles as in
> our environment we do use user defined roles and it has
> always worked for me without any issues .

Thank you, that is extremely helpful.

- John.