Discussion :

[gouilmi]

BONSOIR, J'ai-semble-t-il- perdu toutes mes entrées ds sysloginroles, et de ce fait je n'ai plus de sa/sso role pour mon user 'SA'..!
y a t-il un moyen de GRANTER ces rôles a nouveau.

BCP / INSERT ne marche pas.

Cordialement
MIchel.

bcp master..sysloginroles in sysloginsroles.dat -Usa -c

Password:

Server Message: SYBASE - Msg 10353, Level 14, State 2:

You must have any of the following role(s) to execute this command/procedure: 'sso_role' . Please contact a user with the appropria.

CTLIB Message: - L0/O0/S0/N0/0/0:

blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called.

blk_init failed.

server1:/local/sybase> isql -Usa

Password:

1> sp_configure "allow updates",1

2> go

Msg 10353, Level 14, State 10:

Server 'SYBASE', Procedure 'sp_configure', Line 695:

You must have any of the following role(s) to execute this command/procedure:

'sso_role' . Please contact a user with the appropriate role for help.

(return status = 1)

1>

2>

3>

4>

5> grant role sa_role to sa

6> go

Msg 10353, Level 14, State 1:

Server 'SYBASE', Line 5:

You must have any of the following role(s) to execute this command/procedure:

'sa_role' . Please contact a user with the appropriate role for help.

1> grant role sso_role to sa

2> go

Msg 10353, Level 14, State 2:

Server 'SYBASE', Line 1:

You must have any of the following role(s) to execute this command/procedure:

'sso_role' . Please contact a user with the appropriate role for help.

1> insert sysloginroles values (1,0,0)

2> GO

Msg 10353, Level 14, State 2:

Server 'SYBASE', Line 1:

You must have any of the following role(s) to execute this command/procedure:

'sso_role' . Please contact a user with the appropriate role for help.

1> 2> GO

Suid: 1

Loginame: sa

Fullname:

Default Database: master

Default Language:

Auto Login Script:

Configured Authorization:

Locked: NO

Date of Last Password Change: Dec 15 2005 12:07AM

Password expiration interval: 0

Password expired: NO

Minimum password length: 6

Maximum failed logins: 0

Current failed login attempts:

(return status = 0)

1> select show_role()

2> go

----------------------------------------------------------------------------------------------------------------------------------

NULL

(1 row affected)

1> set role sso_role on

2> go

Msg 10319, Level 14, State 1:

Server 'SYBASE', Line 1:

SET ROLE fails. The caller is not granted with the specified role. Please

contact a user with System Security Officer (SSO) role for help.

1> set role 'sso_role' on

2> go

Msg 10319, Level 14, State 1:

Server 'SYBASE', Line 1:

SET ROLE fails. The caller is not granted with the specified role. Please

contact a user with System Security Officer (SSO) role for help.

1> select suid,name from syslogins where suid=1

2> go

suid name

----------- ------------------------------

1 sa

(1 row affected)

1> select * from sysloginroles where srid=10 and suid=1

2> go

suid srid status

----------- ----------- ------

NULL NULL

1> select user_name()

2> go

------------------------------

dbo

(1 row affected)

1> exit

[Roller]

Bonjour,

disposez vous d'un export logique des principales tables système ?
Si oui, vous pouvez utiliser la méthode suivante, pour reconstruire la master:

http://manuals.sybase.com/onlinebook...w/2238;pt=3045

C'est un peu laborieux, mais ça fonctionne ...

Edit: vous pouvez aussi essayer en mode single user:

http://infocenter.sybase.com/help/in...tsg/X12679.htm

[lparodi]

Aille, ce n'est pa gagné ; : même en single user, et en démarrant le dataserver en empêchant le recovery, les permissions restent vérifiées.
D'expérience, ca se termine par une reconstruction du dataserver

[gouilmi]

ben en fait j'ai fait un 'dd' de mon master de prod et je l'ai reloade sur mon testserver et ca a marche.

merci pr vos reponses.