Hello All!

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
//

Pavel Konovalov
________________________________
JS RCOM 
http://www.rscom.ru


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

Reply via email to