Re: Ynt: [GENERAL] How to drop user if objects depend on it

2015-10-07 Thread Jerry Sievers
Neslisah Demirci writes: > Hi , > > REASSIGN OWNED -- change the ownership of database objects owned by a > database role. > > REASSIGN OWNED BY old_role [, ...] TO new_role > > You can create a new role then you just assign database objects depend on old > role. > REASSIGN owned by old_role to

Ynt: [GENERAL] How to drop user if objects depend on it

2015-10-07 Thread Neslisah Demirci
Hi , REASSIGN OWNED -- change the ownership of database objects owned by a database role. REASSIGN OWNED BY old_role [, ...] TO new_role You can create a new role then you just assign database objects depend on old role. REASSIGN owned by old_role to new_role; Then DROP old_role; Is this