Synchronize system tables between Sybase Servers

Hi All,

I have some doubts regarding what needs to be synchronized
between two sybase servers after a dump&load.

My DEV servers will be completly refreshed (all user
databases) and we want to replicate all the
logins(passwords),roles from PROD to DEV. I believe the best
thing is to BCP in some system tables from prod to dev, so
like this we don't need to fix users in the user databases
after a load, as all suids will match between environments.

I believe I will need to do this for the follow master
system tables:
syslogins
sysloginroles
syssrvroles
sysalternates

my doubt is about sysattributes, as only some object_types
will be needed to be bcp out, but I have no idea.

Can you suggest me the best way to have DEV server in synch
with PROD, assuming that we will copy all the login
information and roles,permissions,groups,etc...

Thanks in advance.
Regards,
Sergio

wrote in message news:48b51299.7794.1681692777@sybase.com...
> Hi All,
>
> I have some doubts regarding what needs to be synchronized
> between two sybase servers after a dump&load.
>
> My DEV servers will be completly refreshed (all user
> databases) and we want to replicate all the
> logins(passwords),roles from PROD to DEV. I believe the best
> thing is to BCP in some system tables from prod to dev, so
> like this we don't need to fix users in the user databases
> after a load, as all suids will match between environments.
>
> I believe I will need to do this for the follow master
> system tables:
> syslogins
> sysloginroles
> syssrvroles
> sysalternates
>
> my doubt is about sysattributes, as only some object_types
> will be needed to be bcp out, but I have no idea.

Class=8, object_type='UR', attribute=2 sysattributes rows hold role
hierarchy information. Per (15.0)
http://infocenter.sybase.com/help/to...les/tables.pdf
the L, U, and GR rows might be needed as well. If the roles have passwords
then some of the PS rows may also be needed.

p.s., Anyone know what a "group role" (GR) is?

>
> Can you suggest me the best way to have DEV server in synch
> with PROD, assuming that we will copy all the login
> information and roles,permissions,groups,etc...
>
> Thanks in advance.
> Regards,
> Sergio