Pavel Konovalov wrote: > Why if delete the user a database, which is grant role > then if this role more nor to grant other users, this role droped? > > create user test_user password test > // > create role test_role > // > // Role test_role exist in dba_roles system table. > // > grant select on test_table to test_role > // > grant test_role to test_user > // > alter user test_user default role test_role > // > drop user test_user > // > // Role test_role was droped too > //
As Thomas wrote on 15. Jan 2002: This is definitely a bug. The role must not be dropped until the role owner is dropped. Will be corrected soon. 'Soon' on 15. Jan. now means: it was corrected in 7.3.0.21, which is available. Elke SAP Labs Berlin BTW: sometimes I love our archives. They really help if one searches for a specific topic as this one is. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
