As saw under schema properties below
A database user can be dropped without dropping objects in a corresponding schema.
My question here is when I am trying to drop a user ex 'testuser' which is tagged to a schema 'testuser' which has few objects (table and function) under that schema.
When I am trying to drop the user am getting a below error msg.
Msg 3729, Level 16, State 1, Procedure sp_revokedbaccess, Line 51
Cannot drop schema 'testuser' because it is being referenced by object 'table'
So i want to know the best method to drop the existing user 'testuser' and recreate it with different set of permissions.
Thanks in advance!!