How to restore permission and the entire hierarchy tree of roles

[STandard]

Hi all,

I would like to run the test for backup/restore sybase database
(Sybase ASE 12.5.1 on Solaris 8).

as I can successfully to restore the master by using bcp out/in, and
retore all user defined databases.

However, I don't know why all the granted roles information is
missing ???
e.g. sp_displayroles A_USER, just 0 rows returned (I have granted the
sa role to A_USER before)

any suggestion???

thanks

steve

[Luc Van der Veurst]

Post by STandard
I would like to run the test for backup/restore sybase database
(Sybase ASE 12.5.1 on Solaris 8).
as I can successfully to restore the master by using bcp out/in, and
retore all user defined databases.
However, I don't know why all the granted roles information is
missing ???

If you want to restore the master database, you can use load database.

If you want to create a new server, then you have to redefine the
information that is in your original master database.

You say that you are using bcp out/in. What tables do you bcp out/in ?

The information about roles can be found in tables :
syssrvroles (roles defined in the server)
sysloginroles (roles granted to users)
sysroles (exists in each db, which roles are used (have
permissions) in the db)

Luc.

[STandard]

thanks, luc

I understand why my problem now.

but i am not sure how to load the master database, is it require to
config the RUN_MY_SERVER file first?
could you mind to show me the steps?

steve

[Luc Van der Veurst]

Post by STandard
I understand why my problem now.
but i am not sure how to load the master database, is it require to
config the RUN_MY_SERVER file first?

Yes, you will have to put the server in maintenance mode.

There should be a chapter in the administration guide explaining
how to recover the master database. Let us know if that doesn't
help.

Luc.

[Rob Verschoor]

You need to boot the server first with the '-m' flag in the RUN_server file.
Then load the master DB dump (requires backup server to run as well). When
loaded, ASE will shut down automatically. Then you can reboot ASE witjhout
the -m flag.

HTH,

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

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

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

mailto:***@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

Post by STandard
thanks, luc
I understand why my problem now.
but i am not sure how to load the master database, is it require to
config the RUN_MY_SERVER file first?
could you mind to show me the steps?
steve