Hi,

when I droped and re-created a database procedure then a database role which was 
granted exectution priviledge became invalid. I did not recognize the invalidity of 
this role. So when a user called this database procedure - he got the execute 
priviledge
on the dbproc through this certain now invalid db role - the database  (v 7.3.0.18) 
crashed: It went "simply" offline without any message.

This situation was reproducable. It was cleared when this certain invalid db role was 
also droped and recreated.

Is this a known bug? Is there a patch available?

Is there a possibility to indicate an invalid db role (maybe some select on 
domain.roleprivileges)?

Thanks in advance!
Frank Schimmelpfennig

PHILIPS Semiconductors Hamburg
ATO-PICTOH  IT&DataSupport
Tel.: +49 40 5613 -1835, Fax: -3020


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to